CONVERTing to US7ASCII from WE8ISO8859P1

Any ideas why the CONVERT function does this?

SELECT CONVERT('información', 'US7ASCII', 'WE8ISO8859P1') FROM DUAL

The SQL above returns "informacion" without the "grave" over the 'o' which is what I want.

However ...

SELECT CONVERT('campaña', 'US7ASCII', 'WE8ISO8859P1') FROM DUAL

Removes the '~' and substitues a '?' and returns "campa?a" I was expecting: "compana"

I am running this SQL on SunOS/Oracle8i. The Oracle8i database character set is US7ASCII.

The data I am trying to load is a text file exported from MS-ACCESS

Any tips or suggestions would be greatly appreciated.

TIA Kevin Received on Sat Jul 14 2001 - 21:33:45 CDT