Importing CSV in chinese language into Sql Server

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Importing CSV in chinese language into Sql Server

Author

Topic

rajan.nithin
Starting Member

42 Posts

Posted - 2012-08-06 : 06:26:25

Hi,

I have a CSV file which has data in chinese language. I am able to insert the data from CSV into a table. But when i retrieve data from the table it shows in some other format.

CREATE TABLE #ClientDetails(clientName nvarchar(50),contactFName nvarchar(50),contactLName nvarchar(50),
contactEmail nvarchar(50),address1 nvarchar(50),address2 nvarchar(50),city nvarchar(50),state nvarchar(50),
zipCode nvarchar(10),country nvarchar(50),mobile nchar(20),userName nvarchar(50)
)

BULK
INSERT #ClientDetails
FROM 'D:\Testing.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)

select * from #ClientDetails

I have also installed the Chinese language pack for windows 7.

What changes should i make to the configuration settings of Sql Server 2008 R2?

Regards,
Nithin

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2012-08-06 : 06:44:21

looks like you need to change collation settings...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources