Re: CONVERTing to US7ASCII from WE8ISO8859P1

Oracle threats theese characters as 'unknown' to the us7ascii character set and therefore the '?'.
You have to replace the characters before inserting into the database (or switch character set in the database).

Kevin wrote:

> 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 Sun Jul 15 2001 - 12:55:16 CDT