How to convert single byte characters to UTF8
cardelNov 10 2009 — edited Nov 13 2009Hi,
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