Charset success (I think)

Well, after all that, here's what finally seems to have worked: create   a database under 9i in US7ASCII, load the data as such, and then use ALTER DATABASE to convert to WE8ISO8859P1. My test page finally does not have question marks where they shouldn't be.

Of course, I'm not done yet. I now have a 3 day old copy of the site in one database and a live copy in the other. But they are both in the same charset and that's a start. Now I have to figure out how I'm going to stitch the two together. I also need to decide if I want to tempt fate and go to UTF-8 now, or do that at a later date when there isn't quite so much interest in getting this fixed yesterday.

It appears that the problem was an 8i bug, as I did this exact same procedure under 8i last night and it didn't work.

Thanks to all for your help and encouragement! If anything else interesting happens with this I will post again.

janine

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