Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: store $FF on Oracle9 with VARCHAR2 type
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