• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Writing query results to an Excel sheet

 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Joe Harry
Ranch Hand
Posts: 10124
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which character set is supported by your database installation? It is stored in the NLS_PARAMETER table.

Select NLS_CHARACTERSET From NLS_PARAMETER
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic