SQLTeam.com | Weblogs | Forums

Import Unicode character data into SQL



Importing non-ascii data which is valid in unicode, gives trouble while importing into SQL.

I wanted to import an excel sheet into my database in SQL Server 2012.
The Excel sheet contains unicode characters (≥ & ≤) which can not be typed from keyboard.
Those characters get deleted / changed while saving.

How do we save it with characters retained?


SPAM reported.