Re: Oracle's Varchar

Login as oracle (or whatever user you're using for oracle managment), and type env | grep NLS_LANG check the results. Meir Kriheli MKsoft computer systems ----- Original Message ----- From: "Olivier Lepretre" <olivier.lepretre@afrilink.net> To: "Meir Kriheli - MKsoft" <mksoft@netvision.net.il> Sent: Wednesday, June 28, 2000 10:57 AM Subject: Re: [PHP] Oracle's Varchar > To be honest, I don't really know, I installed on the US/ENglish language. > For the double byte encoding, the only thing I can say is oracle is > installed on NT and php on linux RH6.2 > > Sqlplus on linux is working fine (gives me good results). Could you tell me > how to check these parameters. Thanks > > ----- Original Message ----- > From: "Meir Kriheli - MKsoft" <mksoft@netvision.net.il> > To: "Olivier Lepretre" <olivier.lepretre@afrilink.net>; > <php-general@lists.php.net> > Sent: Wednesday, June 28, 2000 12:01 PM > Subject: Re: [PHP] Oracle's Varchar > > > > Maybe you're using an NLS_LANG of unicode, or other double > > byte encoding ? check your enviroment. > > > > Meir Kriheli > > MKsoft computer systems > > ----- Original Message ----- > > From: "Olivier Lepretre" <olivier.lepretre@afrilink.net> > > To: <php-general@lists.php.net> > > Sent: Wednesday, June 28, 2000 10:37 AM > > Subject: [PHP] Oracle's Varchar > > > > > > > > When I fetch a column of type varchar2 with php3, php is returning only > the > > halfsize of the column, one caracter on two is a \0. The result is always > > truncated to the size of the column, but including the \0s. > > > > Exemple : column toto is varchar2(10) containing ABCDEFGHIJ > > > > Php is returning : A\0B\0C\0D\0E\0 wich is print ABCDE ... It misses the > > five last letters because Php had already count 10 chars .... > > > > Could anyone help me, I don't want to double the size of all my varchars > > fields !!! > > > > Thanks a lot > > > > > > > > > >