Re: CONVERTing to US7ASCII from WE8ISO8859P1

Hi Kevin,

   I don't know either why it does the o but not the n. But since you are on a UNIX box you have a wealth of tools available to you to make the changes in the text file before you do the data load. Some of those tools are tr, sed, awk, nawk and perl.

                                                Jack

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 Mon Jul 16 2001 - 14:18:36 CDT