Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
UTF-8 non ANSI output (Read 6090 times)
x41andyg
YaBB Newbies
*


I Love SQL*XL

Posts: 3
UTF-8 non ANSI output
12.05.08 at 16:08:26
 
Hi there.
 
I use the OO4O connection to an Oracle Applications 10g database.
 
The database character set is UTF-8 and queries using different tools return Japanese characters correctly.
 
When I run a query using SQL*XL I get "?" question marks. Is there some setting that I am missing that allows the OO4O connection to parse UTF-8 characters into Excel?
 
Cheers
Andy
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: UTF-8 non ANSI output
Reply #1 - 12.05.08 at 19:02:00
 
I do not know how to configure this myself - I would love to know. If you find out please let me know.
 
I have received emails from customers who have done this successfully. Either in the OO4O settings or in the Oracle home it can be specified what the characterset is.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
x41andyg
YaBB Newbies
*


I Love SQL*XL

Posts: 3
Re: UTF-8 non ANSI output
Reply #2 - 13.05.08 at 01:03:19
 
Hi,
 
After some hacking around I found the solution.
 
The NLS_LANG variable needs to be set under the registry key;
 
(in my case, it will be different on your computer, but basically)
 
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1
 
There is a great article showing the list of settings at;
 
(http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_T oc110410556)
 
I simply set the registry value to "JAPANESE_JAPAN.JA16SJIS"
 
and voila SQL*XL in Japanese.
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: UTF-8 non ANSI output
Reply #3 - 13.05.08 at 20:53:04
 
Hi Andy,
 
That is great news. Would you be able to give us a simpel example? It would be nice to get a description of your table to see whether your text columns are varchar or nvarchar, char or nchar and then see the resulting output. Just give us a few lines of data to see how it works.
 
Thanks a lot!
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1