AW: [PHP] VARCHAR2 and writing more than 4000 chars to db

you have to use OCIbindbyname, before executing, after parsing... otherwise it will fail. the syntax is even worse for using CLOBs.... you can find gooooood examples in the manual at www.php.net Sebastian | -----Ursprüngliche Nachricht----- | Von: Frank M. Kromann [mailto:fmk@swwwing.com] | Gesendet: Dienstag, 31. Oktober 2000 23:14 | An: simon.pospisil | Cc: php-general@lists.php.net | Betreff: Re: [PHP] VARCHAR2 and writing more than 4000 chars to db | | | Some databases do not support direct insets or updates if a | single comumn is more than 2000-4000 chars. You should use blobs | or some kind of server specific code to handle this type of data | (I asume it would be impossible so switch to another database | where large text colums are allowed ?) | | - Frank | | >Hello everyone, | > | >I am using VARCHAR2. The user enters the text into an html form | textbox which I would like to then add to the database. | Unfortunately, I think this means that I cannot add text more | than 4000 characters long. I have a feeling I should be using | blobs or such like, but I haven't used them before. Has anyone | else experienced this problem? Have you got any tips? I use Oracle 8. | > | >Thanks, | > | >Simon. | > | | | | | -- | PHP General Mailing List (http://www.php.net/) | To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net | For additional commands, e-mail: php-general-help@lists.php.net | To contact the list administrators, e-mail: php-list-admin@lists.php.net |