Home » Developer & Programmer » Forms » convert single byte characters to UTF8 (Forms 6i, winxp)
convert single byte characters to UTF8 [message #430186] Mon, 09 November 2009 06:57 Go to next message
Messages: 21
Registered: April 2008
Junior Member
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
Re: convert single byte characters to UTF8 [message #432406 is a reply to message #430186] Mon, 23 November 2009 23:50 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Go to http://www.orafaq.com/search?keys= and search for 'utf8'. There may be a solution in that lot.

Previous Topic: Form 6i: Is character mode full screen menu possible?
Next Topic: ORA-01747 on item from query
Goto Forum:

Current Time: Mon Oct 24 02:24:19 CDT 2016

Total time taken to generate the page: 0.10386 seconds