Re: URGENT HELP REQUIRED - long data types not being returned correctly

Hi,

Edwinah63 schrieb:
> Hi Jim,
>
> have checked the length of the notes field using a quick query in
> Access ;-)
>
> the longest is about 15,000 chars. presuming each character is a
> byte, then we are returning about 15k back - below the limit of 32 k.
> or am i missing something here???

Just two ideas:
What character set do you use in your database? Oracle also supports multibyte character sets. In this case your presumption could be wrong.

Did you try to use the dataype LOB instead of LONG? Does the problem persist in this case?

-- 
Mit freundlichen Grüßen / Best regards
Michael Gast
SEPP MED GmbH

All emails sent to this address are never read and never will be
answered. Sorry, but until someone cleans up the spam mess, that's the
way it has to be.

E-Mails, die direkt an diese Adresse geschickt werden, lese und
beantworte ich nicht. Ich bedauere diesen Umstand sehr, kenne derzeit
aber keine bessere Möglichkeit, um die Spam-Flut abzustellen.