Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: URGENT HELP REQUIRED - long data types not being returned correctly

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

From: Edwinah63 <edwinah_at_customercare.com.au>
Date: 20 Jun 2004 16:45:04 -0700
Message-ID: <d714e824.0406201545.5aeec01b@posting.google.com>


Hi Michael,

thanks for your suggestions.

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

the database is set up with WE8MSWIN1252. i have confirmed with Oracle Tech Suport that this is a single byte character set

so am i still right in presuming that each characted is only worth 1 byte?

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

it has been the weekend in Australia so i will try this one this week.

kendest regards

Edwinah63 Received on Sun Jun 20 2004 - 18:45:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US