Re: CONVERTing to US7ASCII from WE8ISO8859P1

From: danisment <danisment_at_yahoo.com>
Date: 15 Jul 2001 16:46:53 -0700
Message-ID: <2c78cfac.0107151546.42a45c97@posting.google.com>

Hello,

Note that character conversions are not limited to client tool and db. client's terminal is important, too.

See http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400752 for further info.

danisment...

Kevin <kpd98_at_worldnet.att.net> wrote in message news:<3B51005C.D19F6BBC_at_worldnet.att.net>...
> 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 - 18:46:53 CDT