Click here to Skip to main content
12,356,681 members (60,443 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
I Want To Upload Unicode To Sql Server and Retrieve Uploaded Data
how to do this.. ?
Posted 28-Jan-13 21:28pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

See - UNICODE (Transact-SQL) [^]

Cheers,
Edo
  Permalink  
Comments
Edo Tzumer 29-Jan-13 5:51am
   
Tnx Sisir
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

You need to set the column as nvarchar

and before inserting the value to column use N'

eg

update dbo.Supplier
SET FirstNameLocalLang=N'英商'
WHERE Supplier_id=30052810

INSERT INTO supplier VALUES (N'汉字/漢字'')

No changes required in C# code and while selecting no need to do anything. Keep the usual select query
  Permalink  
v3
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You need to define your target table fields as nvarchar and load you data using an ADO connection just like any other data.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 29 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100