| CLOB & characterset [message #333532] |
Sat, 12 July 2008 04:43  |
radian7
Messages: 1
Registered: July 2008
|
Junior Member |
|
|
Hello
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 #333604 is a reply to message #333532] |
Sun, 13 July 2008 09:17  |
 |
Kevin Meade
Messages: 2103
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.
dbms_lob.append
Good luck, Kevin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
