Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: store $FF on Oracle9 with VARCHAR2 type
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 DBAReceived on Fri Jul 22 2005 - 04:11:12 CDT