note 19583 deleted from ref.oci8 by maxim

From: 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.

« previous php.notes (#39403) next »