[PHP-DEV] Re: [PHP3] Where is my last Char going?! (fwd) From: Zeev Suraski (bourbon <email protected>)
Date: 06/30/98

Anybody looking into it? I want it to make it into 3.01, and I want to
release 3.01 on Thursday (and that's already in a one week delay...)

Zeev

---------- Forwarded message ----------
Date: Sun, 28 Jun 1998 20:09:44 -0400 (EDT)
From: Asian Avenue <ccimail <email protected>>
To: Zeev Suraski <bourbon <email protected>>
Cc: Richard Lynch <lynch <email protected>>, php3 <email protected>
Subject: [PHP-DEV] Re: [PHP3] Where is my last Char going?!

Does there seem to be any status report on this?

Mike

>
> This appears to be a bug in the Oracle module. I hope it can get sorted
> out before 3.01.
>
> Zeev
>
> On Fri, 26 Jun 1998, Asian Avenue wrote:
>
> > Just spoke with Oracle-
> >
> > CREATE TABLE myTable
> > (
> > Gender VARCHAR2( 6 )
> > ) ;
> >
> > Reserves all 6 bytes for DATA....Oracle then handles the null terminator
> > for this string by adding ONE to the character length here. The folks
> > there told me that any C strings used to handle data coming back from
> > Oracle MUST BE increased in size by one byte.
> >
> > I apologize for making all this noise....I am OK with increasing all of MY
> > data lengths beyond that they are now. Anyone have any clues what I do in
> > the case of the ROWID field? I am not asking Oracle to return its native
> > ROWID type (this does not seem to be supported by Oracle) but instead
> > converting it to a character string FIRST...then having it returned:
> >
> > SELECT ROWIDTOCHAR( ROWID ) FROM myTable WHERE Gender = 'Female' ;
> >
> > Mike
> >
> > -=> Get you FREE Internet E-mail account now at
> > http://www.CommunityConnect.com
> >
> > Michael C. Montero
> > Vice President of Technology
> > Community Connect Co-founder
> > Asian Avenue Member
> > Mike <email protected>
> >
> > -=-=-=-=-= Community Connect Inc. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >
> > The Premier Source of Interactive Online Communities 25 Broad Street
> > http://www.CommunityConnect.com New York, NY 10004
> >
> > http://www.AsianAvenue.com
> > The Interactive Online Community for Those of Asian Heritage
> >
> > ----- Your Message May Appear Below This Line
> >
> > On Fri, 26 Jun 1998, Asian Avenue wrote:
> >
> > > Yes, I have increased the size of Gender field to 10 just to be asolutely
> > > safe. In fact, I have gone through all tables and done this. It was
> > > quite difficult. The problem is that I have no control over the ROWID
> > > field since it is maintained by the rdbms.
> > >
> > > Ugh......thanks for the help! Any further ideas?
> > >
> > > Mike
> > >
> > > -=> Get you FREE Internet E-mail account now at
> > > http://www.CommunityConnect.com
> > >
> > > Michael C. Montero
> > > Vice President of Technology
> > > Community Connect Co-founder
> > > Asian Avenue Member
> > > Mike <email protected>
> > >
> > > -=-=-=-=-= Community Connect Inc. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >
> > > The Premier Source of Interactive Online Communities 25 Broad Street
> > > http://www.CommunityConnect.com New York, NY 10004
> > >
> > > http://www.AsianAvenue.com
> > > The Interactive Online Community for Those of Asian Heritage
> > >
> > > ----- Your Message May Appear Below This Line
> > >
> > > On Fri, 26 Jun 1998, Richard Lynch wrote:
> > >
> > > > At 1:26 PM 6/26/98, Asian Avenue wrote:
> > > > >I have the following table in Oracle:
> > > > >
> > > > >CREATE TABLE myTable
> > > > >(
> > > > > Gender VARCHAR( 6 )
> > > > >) ;
> > > >
> > > > Caveat Emptor: Wild guesses and hypotheses abound:
> > > >
> > > > Oracle/PHP/something needs an extra char for the '\0' end-of-string
> > > > character at the end of each VARCHAR.
> > > >
> > > > You may have corrupted your databases by trying to stuff 'FEMALE\0' into a
> > > > six-character field, so ROWID breaking may be just a symptom of this
> > > > corruption.
> > > >
> > > > Make the fields an extra character across the board, and try for ROWID
> > > > again. If it's still broken, come back.
> > > >
> > > > Disclaimer: Any other answer you receive is likely to be more correct.
> > > >
> > > > --
> > > > --
> > > > -- "TANSTAAFL" Rich lynch <email protected>
> > > >
> > > >
> > >
> > >
> > > --
> > > PHP 3 Mailing List http://www.php.net/
> > > To unsubscribe send an empty message to php3-unsubscribe <email protected>
> > > To subscribe to the digest list: php3-digest-subscribe <email protected>
> > > For help: php3-help <email protected> Archive: http://www.tryc.on.ca/php3.html
> > >
> > >
> >
> >
> > --
> > PHP 3 Mailing List http://www.php.net/
> > To unsubscribe send an empty message to php3-unsubscribe <email protected>
> > To subscribe to the digest list: php3-digest-subscribe <email protected>
> > For help: php3-help <email protected> Archive: http://www.tryc.on.ca/php3.html
> >
> >
>
> --
> -----------------------------------------------------
> Zeev Suraski <zeev <email protected>>
> For a PGP public key, finger bourbon <email protected>
>
>
>
> --
> PHP 3 Mailing List http://www.php.net/
> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest list: php3-digest-subscribe <email protected>
> For help: php3-help <email protected> Archive: http://www.tryc.on.ca/php3.html
>
>