OraFAQ Forum: Forms » convert single byte characters to UTF8

Home » Developer & Programmer » Forms » convert single byte characters to UTF8 (Forms 6i, winxp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

convert single byte characters to UTF8 [message #430186]

Mon, 09 November 2009 06:57

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

Report message to a moderator