Re: Converting to specific character set

On Thu, 25 Oct 2001 15:07:33 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"_Andy_" <withheld_at_address.com> wrote in message
>news:3bd7ee6e.507143453_at_news.colt.net...
>>
>> I need a way of converting an ANSI field to UTF8. Is there an Oracle
>> function I can use to do something like:
>>
>> select to_utf8(name) from my_table where id=1234;
>>
>> ??
>>
>> Cheers,
>>
>> Andy
>>
>
>Please check out the string functions in the sql reference manual.
>The function is called -guess what- convert

Sorry, I worked that out in the end. What about CLOBs? A clob contains an ISO8859-1, but

convert( dbms_lob( clob_field , 1000 , 1 ) , 'WE8ISO8859P1' , 'UTF8' )

doesn't work - rubbish characters are returned.

Any ideas? Received on Thu Oct 25 2001 - 10:20:12 CDT