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

Home -> Community -> Usenet -> c.d.o.server -> Re: store $FF on Oracle9 with VARCHAR2 type

Re: store $FF on Oracle9 with VARCHAR2 type

From: Svend Jensen <svend.SPAMKILLjensen_at_secret.dk>
Date: Thu, 14 Jul 2005 19:33:03 +0200
Message-ID: <42d6a210$0$34318$edfadb0f@dread11.news.tele.dk>


pcouas_at_infodev.fr wrote:
> Hi,
>
>
> Before i use an Oracle8.0.4 on AIX 4.3.2 and i could store $FF value
> in VARCHAR2 type.
> Now i have an Oracle9.2.0.4 on Redhat and $FF are translated to $7F,
> I could not use RAW type
> My Charset is US7ASCII
> So, How could i store $FF ?
>
> Thanks
> Philippe

You can't.

You use 7 bit us-ascii, max. value for 7 bit is 0x7F.

Create new 8 bit database or switch charset.

rgds
/Svend Received on Thu Jul 14 2005 - 12:33:03 CDT

Original text of this message

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