Re: Character size

There are ways, but they are not pretty. I've been playing around with some of this stuff because we have some multi-byte characters from a legacy system that somehow got stored in a US7ASCII DB when they converted to ORACLE years before I got on site. The only way I found that we could extract the data was by using the dump() function to look at the actual internal code format. I found that you could also store 8 bit or even multi-byte data in a US7ASCII DB by using the chr() function.

This makes application coding unwieldy and complex. We used the technique to pull the data out and store in 8 bit or multi-byte databases that we set up to get rid of the 7 bit problem.

As for export/import, no combination of NLS_LANG and database char sets could be found that would preserve the multi-byte data stored in a 7 bit DB when trying to import them into an 8 bit or multi-byte DB

Good luck

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Van Messner <vmessner_at_bestweb.net> wrote in message
news:6%Co5.2516$kM2.322157_at_newshog.newsread.com...


> Our newer databases have been created with the 8-bit Western European

> character set.  Older ones are USascii7.  Is there any way to store

 accented


> European characters on the older databases?  If so, what happens when we

> export/import to the newer ones?  Are the accented characters saved?

>

> Thanks,

>

> Van

>

>