April 29, 2009 at 3:50 am
Help needed in displaying the japanese character on sql server 2005, it is dispalyed as inverted ? marks.
What collation should I used to import japanese char ( display japanese char) in sqlserver 2005, while creating db in sqlserver.
I am importing it from oracle 10g (character set JA16SJIS).
I Have taken export from sqldeveloper to excel, then importing it from excel to sqlserver I am able to see the japanes character,
however
With excel I am facing the below problem
1. Number of records in some of the tables are more than 200000.
2. Leading zeros, truncation issues etc.
Regards,
April 29, 2009 at 3:01 pm
Excel 2003 has a row limit . I suggest use Excel 2007 it has a row limit of 65536.:-D
April 30, 2009 at 5:10 am
Hi
The collation doesn't matter for the storage of these characters. The collation describes the sorting and matching of the text data. Use column type NVARCHAR and everything works. We handle Arabic text in our system and have no problems.
Greets
Flo
April 30, 2009 at 5:12 am
kbotha80 (4/29/2009)
Excel 2003 has a row limit . I suggest use Excel 2007 it has a row limit of 65536.:-D
Hi kbotha80
65,536 was the Excel restriction until 2003. Since Excel 2007 you can handle 1,048,576 rows and columns up to XFD. 😉
Greets
Flo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply