note 19583 deleted from ref.oci8 by maxim
| From: | maxim@php.net | Date: | Tue, 12 Nov 2002 16:57:52 +0000 |
| Subject: | note 19583 deleted from ref.oci8 by maxim | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-39403@lists.php.net to get a copy of this message | ||
It seems as though the Oracle functions in PHP use the Oracle8 contraints on datatypes, not Oracle8i
or higher. For example, the VARCHAR2 datatype in Oracle8i can have a size up to 4000 bytes. When you
return the results from A field using this type that has more than 2000 bytes using the OCI
functions in PHP it only returns 2000 bytes of the field. Additionally, when you try to do an insert
or update to the field with more than 2000 bytes an error (Warning: OCIParse: ORA-01756: quoted
string not properly terminated ). In Oracle8 the constraint on size for the VARCHAR2 datatype was
2000 bytes. This is how I arrived at my conclusion. Additionally, the documentation only mentions
Oracle* and not Oracle8i. Hopefully this will be corrected in a future version.