Home » SQL & PL/SQL » SQL & PL/SQL » CLOB & characterset (Oracle 9i)
CLOB & characterset [message #333532] Sat, 12 July 2008 04:43 Go to next message
Messages: 1
Registered: July 2008
Junior Member

I have oracle database 9i with ISO 8859-2 characterset.

In my functions I use CLOB variables.
I want to return CLOB in UTF-16 encoding.

How can I do it ?
How can I convert CLOB variable to UTF-16 ?

Thanks for any help.
Re: CLOB & characterset [message #333547 is a reply to message #333532] Sat, 12 July 2008 09:06 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guideline as stated above

full export & import is only way

[Updated on: Sat, 12 July 2008 09:21] by Moderator

Report message to a moderator

Re: CLOB & characterset [message #333550 is a reply to message #333532] Sat, 12 July 2008 09:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CLOB as well as other string fields are returned in the client character set.

Re: CLOB & characterset [message #333604 is a reply to message #333532] Sun, 13 July 2008 09:17 Go to previous message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
Most people do not deal with character set conversions in any regularity, including me. Thus this will be a difficult question to get an answer for, and you might want to post on metalink asking oracle for help.

In the meantime maybe you can write yourself a function using DBMS_LOG.APPEND. I seem to recall you can feed in a clob in one characterset and append it to a clob using a different characterset. I presume this converts the clob data between charactersets. But as I said, this is not an area I spend any time in so this is just a guess and you will have to do some testing to make sure you are getting what you want.


Good luck, Kevin
Previous Topic: open-for-using statement
Next Topic: How to write the query?
Goto Forum:

Current Time: Fri Aug 18 03:42:19 CDT 2017

Total time taken to generate the page: 0.11175 seconds