View previous topic :: View next topic |
Author |
Message |
batman77
Joined: 26 Jul 2006 Posts: 1
|
Posted: Thu Jul 27, 2006 7:18 pm Post subject: Chinese Charachters Displaying as ??????? in DataLoad Sheet |
|
|
Hi. I have an excel spreadsheet that I am trying to load into dataload.
2 Columns are that chinese charachters are displayed perfectly in excel, as i have the chinese langauge option loaded in my regional settings. I also can view chinese symbols perfectly via ODBC connections to live oracle tables... but when i try to paste in my values into dataload, all i get are "?????????"
I have tried setting the display font to Arial MS Unicode, and have tried the UTF8 check box option...which is what i believe displays chinese OK
Any suggestions?
Thanks |
|
Back to top |
|
|
DataLoad Site Admin
Joined: 15 Nov 2005 Posts: 231 Location: Dorset, UK
|
Posted: Thu Jul 27, 2006 7:33 pm Post subject: |
|
|
Hi,
This issue is caused by DataLoad not being able to display the Chinese characters correctly. The UTF-8 checkbox does not affect the display but instead causes forms playback (FLD) files to be saved in Unicode UTF-8 format, which is required if your database character set is UTF-8. This option has no effect for macro (DLD) loads.
The two key things to get right for DataLoad to be able to display Chinese or any other multi-buyte language are:
1. Font (In particular, don't use a Unicode font as you have currently selected)
2. PC's regional language settings.
Please see the following forum thread for more information on these points:
http://www.dataload.net/forum/viewtopic.php?t=11
Regards,
Jonathan Stuart,
DataLoad Support. |
|
Back to top |
|
|
|