convert single byte characters to UTF8 [message #430186] |
Mon, 09 November 2009 06:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cardel
Messages: 21 Registered: April 2008
|
Junior Member |
|
|
Hi,
I have problem with exporting data to file with UTF8 encoding.
I have varchar2 columns in database with NLS_CHARACTERSET = EE8ISO8859P2 (Czech) and I need to export this columns into file with UTF8 encoding.
So I need to make single byte TO multi byte conversion.
I tried sql CONVERT (CONVERT('my_char','UTF8')) command in forms, but with no effect. Encoding of created file is UTF8 but characters are corupted.
Settings in registry on my client is NLS_LANG = AMERICAN_CZECH REPUBLIC.EE8MSWIN1250
Could you tell me some trick how to export column data with single byte characters to file with UTF8 encoding?
I am using Text_io package to write to file from forms.
Thank You
|
|
|
|