Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2009-04-28 : 07:28:25
|
| Hi all,plz help me in displaying the japanes character on sql server 2005, it is dispalyed as inverted ? marks.What collation should I used to import japanese char ( display japanes char) in sqlserver 2005, while creating db in sqlserver.I am importing it from oracle 10g ( character set JA16SJIS).Regards, |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2009-04-28 : 09:05:21
|
| If you're saying that any Japanese character you try to import gets turned into an inverted question mark () then I don't know what the problem is.If you're saying that HALFWIDTH KATAKANA LETTER SO (looks a bit like a y) is turning into inverted question mark (¿) and other Japanese characters are turning into other strange things (but not Japanese-looking -- for example if a SJIS string for "Nihongo" gets imported like this: "“ú–{Œê"), then the problem is that something in the import is treating the bytes that make up the SJIS string as if they were ISO Latin 1 characters.You can store Japanese text in a varchar/char with a Japanese collation, or any nvarchar/nchar column (irrespective of collation).In the varchar/char case, it will be stored as SJIS (aka Windows code page 932) internally, but unless something in the import is bypassing any notion of character and just shoving bit patterns into the column, I don't see how that helps really.Edit: getting non-ASCII characters into SQL Team forum posts is painful! |
 |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-28 : 11:14:59
|
| hmmm, I have taken export from sqldeveloper to excel, then importing it from excel to sqlserver I am able to see the japanes character,however it will take more time, as I have to do it table wise, and the no of tables are more.Any help appreaciated.Regards, |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-04-29 : 04:03:43
|
| Any updated on this, how to bring in the japanese char to sqlserver,With excel I am facing the below problem1. Number of records in some of the tables are more than 200000.2. Leading zeros, truncation issues etc. |
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-05-07 : 03:23:06
|
| Any updateds on this, I am able see the japanese char in sqlserver after using SSMA for oracle migration tool from Microsoft.however I am getting over flow error. any help in this regards will be appreciated. |
|
|
|
|
|
|
|
|
japanes character set displayed as inverted ? mark