Re: store $FF in Oracle9 and with VARCHAR2 ?

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 ?

$FF is not part of ascii (a 7 bit character set), and in these days of things like utf-8 etc, products like Oracle are becoming much more rigorous in their handling of character sets issues.

I would guess that any 8 bit character set would allow you to store that value in the character data.

--

This space not for rent.