Both have regional settings of English (UK) in the Windows OS. Which brings me back to my post which may have been missed:


Originally posted by JMac
We have a Trademark symbol ™ in our 8i database. I did an export and imported it into a 9i database. It appears in the 9i database as ¿. I know ¿ is the default character when Oracle can't transalte a character.Hence my concern.

Anyone have any ideas or comments as to why this happened? I know ™ isn't a transportable character but if 8i and 9i charsets are compatible why can the exp/imp not translate the char?
I'm just confused why 1 symbol in the 8i DB wasn't imported correctly into the 9i DB when both have apparently compatible character sets?