CHARSET CONVERSION [message #597230] |
Tue, 01 October 2013 14:56 |
|
sreedi
Messages: 1 Registered: October 2013
|
Junior Member |
|
|
Hi,
I'm trying to retrieve data stored in VARCHAR2 column of a table in CHARSET LATIN1 (ISO-8859-1) which is same as the Database Server charset. My Client windows machine NLS_LANG is set to 'WE8MSWIN1252'
I tried using utl_raw.convert(utl_raw.cast_to_raw(comment_text),'AMERICAN_AMERICA.AL32UTF8','AMERICAN_AMERICA.WE8ISO8859P1');
Note:- data in this VARCHAR2 column is stored from Java client that uses UTF-8 charset after converting to ISO-8859-1.
This doesn't seem to be work as some special chars liek ' and " are not converted and weird charachters are displayed.
However, I'm able to convert this data back to UTF-8 charset from ISO-8859-1 charset using Java String objects without any issues.
I have a constraint that I cannot use Java for this reverse conversion and it has to be in PL/SQL. Appreciate any suggestions.
Thanks
|
|
|
|