Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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...Received on Wed Aug 23 2000 - 11:43:40 CDT
> 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
>
>