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