Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting to specific character set

Re: Converting to specific character set

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 25 Oct 2001 15:07:33 +0200
Message-ID: <ttga0lo7ikjm37@corp.supernews.com>

"_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

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 25 2001 - 08:07:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US