cancel
Showing results for 
Search instead for 
Did you mean: 

Unicode MSSQL

former_member189418
Participant
0 Kudos

Hi All,

I'm inserting japanese charecters into MSSQL server. when i do that, i can see in the insert query in th audit log with japanese charecters. but in the MSSQL server, they are inserted as ?????. the columns are already defined in the MSSQL as the data types <b>nchar</b> and <b>nvarchar</b>

I modified the <b>URL</b> with charset <b>UTF-8</b>. i had also tried with the option sql7=true. but no use....

Can anyone help me in this regard.

Regards

Anil

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hai,

Are you able to insert the japanese characters in notepad in the system where the server installed. If it is a cuase install the japanes font in ur server system.

regards,

Naga

former_member189418
Participant
0 Kudos

Hi Naga Raju,

The Japanese charecters are getting inserted on the server sys. but i think it doesnt help as we are able to see the japanese charecters in the Update query from the runtime workbench. there must be some parameter (might be in the database URL) setting missing in the adapter configuration i believe.

Please let me know if u hav any ideas?

Anil

former_member189418
Participant
0 Kudos

Any help guys?

vincentlim826
Employee
Employee
0 Kudos

Are you able to insert the japanese characters into other OS application, i.e notepad with no problem ?

former_member189418
Participant
0 Kudos

Hi Vincent,

Yes...if i can paste the query from the audit log into a wordpad document, the japanese charecters are visible

Any help wud b appreciated.

Anil

vincentlim826
Employee
Employee
0 Kudos

Hi Anil,

hmmm....tricky..

For a unicode system SQL Server uses the datatype "nvarchar".

For a non-unicode system SQL Server uses the datatype "varchar".

SQL Server always uses UNICODE UCS-2 character set (2 bytes per

unicode character) independent from the collation of the SQL S

You can always store 10 unicode characters in a field defined

nvarchar(10).

A collation defines the code page and sort order. SAP only support

the collation SQL_Latin1_General_CP850_BIN2 for unicode system.

Did you install the correct collation ? See SAP note 600027.

or maybe you can look for Microsoft Support on this case ?

cheers,

Vincent

former_member189418
Participant
0 Kudos

Hi Vincent,

The note says installing the SQL SErver DB for SAP System. but in my case the DB system for SAP is DB2 and the SQL Server is the reciever of the message.

Any clue guys?

Anil