Writing eatern characters to SQL Server

Brought to you by: cbegin

Writing eatern characters to SQL Server

Forum: CLOSED - Users

Creator: Nobody/Anonymous

Created: 2003-07-09

Updated: 2003-07-10

Nobody/Anonymous - 2003-07-09

Hi! I know this is not the problem of iBatis (may be) but I guess I can get some advise from some the best database experts here. I need to write some chinese in GB coding to a SQL database, but all I get are some ????? which is not quite useful. Would please some one point me to some references so I can get some idea on how to code them. I know that the values in the object are not messed up, as I can actually display them out to the console.

Thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Nobody/Anonymous - 2003-07-09
  
  Sorry, typo on the title. Should be "eastern characters". Thanks again!
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Clinton Begin - 2003-07-10
  
  Sorry, I won't be of much help here. As far as I know, you'll need to set the character/code set appropriately. This could be a setting in your RDBMS software, per database instance, driver configuration, or even an operating system configuration (if the RDBMS defaults to the OS settings).
  
  In DB2 for example, I think it is set per database instance:
  
  CREATE DATABASE <databasename> USING CODESET UTF-8 TERRITORY US
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.