Re: Replacement of US7ASCII character set in 11g?

I ran CSSCAN on the original 8.1.7 database and, of course, ran into trouble right away. The conversion from US7ASCII to WE8MSWIN1252 is lossy in a number of places. This does not surprise me terribly; Jared mentioned that you can put "invalid" data into a database of type US7ASCII and I'm pretty sure that all of the programmers who have worked on this site over the years have just assumed that if the database didn't choke on it, then it was ok.

What concerns me is that CSSCAN reports that converting to UTF8 will have the exact same lossy conversions. The two error files are literally identical except for the value of TOCHAR. I thought that UTF8 was the mother of all character sets, so where do I go from here?

As an example, one of the first errors reported looks like this when I do a SELECT in sqlplus:

Lic. en medios de comunicaciÃ?3n

I will be digging further into this, with The Google and all, but if anyone has any light to shed, please do!

janine

On Jan 7, 2010, at 3:07 PM, David Mann wrote:

> When I had clients worried about character set conversions I usually
> ran Character Set Scanner utility CSSCAN on a copy of the database
> to check for differences. Here is the reference in the 10g
> documentation, assuming it is still available in 11g but don't have
> a link handy.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm
>
> --
> Dave Mann
> www.brainio.us
> www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml

--
http://www.freelists.org/webpage/oracle-l