on 04-18-2007 3:25 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Are you able to insert the japanese characters into other OS application, i.e notepad with no problem ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.