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 that Branimir, Carsten and I encountered
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
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.