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: <sybrandb_at_yahoo.com>
Date: 22 Jul 2005 02:11:12 -0700
Message-ID: <1122023472.570371.232090@g47g2000cwa.googlegroups.com>


So the MSB is stripped off, and you have a 7-bit characterset (or 7-bit characterset settings) in the database/ on the database server, and 8-bit settings at the client side.
Or in the past, you had 7-bit client and 7-bit database. As charactersets are equal, there will be no conversion and bit 7 will pass. However, as soon as you export it, using 7-bit NLS_LANG settings, exp will strip bit 7.
And when you re-import it, the 8-bit characters won't automagically arise from their grave.
(This only 'appens in the British comedy 'Allo 'Allo, where the bravest man of France is catapulted from his grave on a telescope antenna ;)

Hth

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Jul 22 2005 - 04:11:12 CDT

Original text of this message

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