Re: oracle & varchar -problem

Yes,this is a wll-known problem. There was a thread with the same subject about a month ago. If I remember correctly, the solution is to properly define NLS_LANG. But you'd better check with the archives. -Stathis. Michael Howitz wrote: > > hi! > > I'm new to this list & I have a maybe really old question: > > I'm using php4 to access an 8.1.5-oracle database through oci8. > when i have a varchar2-column (it is 256 or 4000 bytes long) to SELECT from, > I get a stange behavior: > I get a string which is twice as long as the contents of the varchar2-field > and this string contains only 0h-values (null-values). > this behavior is shown when I use OCIResult() and OCIFetchInto(), too. > however, numbers are displayed correctly. > > is this a (well) known problem? has anybody a solution for it? > any help welcome. > > thanks in andvance, > mac > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- +-----------------------------+ |Rouvas Stathis | |University of Athens | |Department of Informatics | |http://www.di.uoa.gr/~rouvas | |rouvas@di.uoa.gr | +-----------------------------+