Re: CORRECTion 254 not Weird advice : keep varchar2 under 255 bytes ???

From: Jack <none_at_mail.com>
Date: Sat, 16 Apr 2005 04:30:05 GMT
Message-ID: <hx08e.21$6U5.11@read3.inet.fi>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:6ldt51lhi0vq8seaadmgc0bvelgu5filp7_at_4ax.com...
> On Thu, 14 Apr 2005 21:08:40 +0300, "Jack" <Jack_at_none.com> wrote:
>
>> Bug No. 3166218
>>
>> 1. Clear description of the problem encountered:
>> Using Generic Connectivity (ODBC-Driver) to DB2/400 long string values
>>are
>>
>> truncated to 254 characters when using a BIND variable
>>
>>DAM ORACLE !!!
>
> Do you know *ANY* bug free database product? Can You do better?
> No?
> Then stop shouting.
>
> Apart from that, who is using Oracle in conjunction with DB2 on AS400?
> Not Serge Rielau!
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Now Looks better when Oracle found that one-off fix:

Run a simple search specifying '3166218' as 'Patch Number'

And BTW Oracle runs well on my wireless Symbian series PDA (Nokia phone) ;)

Jack Received on Fri Apr 15 2005 - 23:30:05 CDT