Re: Oracle8 and varchar
| From: | Olivier Lepretre | Date: | Thu, 29 Jun 2000 07:36:33 +0000 |
| Subject: | Re: Oracle8 and varchar | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-736@lists.php.net to get a copy of this message | ||
Hi :
You saved me !!!!!
Thank's a lot !!
----- Original Message -----
From: <thies@digicol.de>
To: "Olivier Lepretre" <olivier.lepretre@afrilink.net>
Cc: "Rouvas Stathis" <rouvas@di.uoa.gr>; <php-db@lists.php.net>
Sent: Wednesday, June 28, 2000 8:26 PM
Subject: Re: [PHP-DB] Oracle8 and varchar
> On Wed, Jun 28, 2000 at 12:23:35PM +0200, Olivier Lepretre wrote:
> > Hi Rouvas :
> >
> > This is the code. the column b.proc_desc is the varchar2(20) causing
problem (and all varchar2 fields are causing me the same problem). if the
value is for example GUIDE, the function strlen returns a size of 10 ....
but the real size is 5 .... After investigation, it appears that the string
is composed of G\0U\0I\0D\0E\0 .... strange isn't it ?
> >
> > The server is ORA/NT 8.0.5, client is on RH6.1 ORA8.0.x
>
> please set ORACLE_HOME, ORACLE_SID and NLS_LANG *before* you
> start your apache. (not in httpd.cong and not usign putenv in
> your script.) that's most likely to solve your trouble.
>
> tc
>
> <snip>
>
> --
> 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
>