| Author |
Writing query results to an Excel sheet
|
Joe Harry
Ranch Hand
Joined: Sep 26, 2006
Posts: 8795
|
|
Guys,
I'm writing the results of a query to an Excel sheet and what I have in my tables are encoded form of some chineese characters. So when I do it, I'm not able to decode those chineese characters and print in the excel sheet but instead I'm getting the same encoded value as it is from the database. Please help me on this.
|
SCJP 1.4, SCWCD 1.4 - Hints for you, SCBCD Hints - Demnachst, SCDJWS - Auch Demnachst
Did a rm -R / to find out that I lost my entire Linux installation!
|
 |
Joe Harry
Ranch Hand
Joined: Sep 26, 2006
Posts: 8795
|
|
Exactly here is what I want,
Through my JSP, I store some chineese names in my Oracle database. The chineese letters gets stored in an encoded form. Now I want to generate a xls report where I just run a query with a java helper class and write the output to a xls. Now in the xls, I'm just getting the encoded form but I'm not able to get the chineese letters back. Please help me!
|
|
Paul Campbell
Ranch Hand
Joined: Oct 06, 2007
Posts: 338
|
|
Which character set is supported by your database installation? It is stored in the NLS_PARAMETER table.
Select NLS_CHARACTERSET From NLS_PARAMETER
|
|
 |
|
|
subject: Writing query results to an Excel sheet
|
|
|
0
