Re: Storing 8-bit characters in a VARCHAR2

From: <holmesb_at_my-dejanews.com>
Date: Thu, 10 Dec 1998 19:11:05 GMT
Message-ID: <74p6c7$r8m$1@nnrp1.dejanews.com>

In article <01be2415$fbdefa40$2b00a8c0_at_eft43>, "Philippe Lepot" <plepot_at_eft.be> wrote:
> Hi,
>
> We developed an application under Oracle7. We are storing 8-bit characters
> (i.e. binary data) in a VARCHAR2 field. The program runs fine under Oracle
> 7.3 but fails under Oracle8 because the server maps characters above ASCII
> 128 to equivalent under 128. For A with accent is mapped on to A (ASCII
> 65). We checked the NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET of Oracle8.
> They have the same value as under Oracle7. Does anybody know how to prevent
> this mapping from happening from a ESQL/C program.
> Thanks in advance.
>
> Philippe
>

Are you using WE8ISO8859P1 (for English) or the equivalent character set for your language?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 10 1998 - 13:11:05 CST