SQL Server 2012 Express LocalDB parm for keeping unicode char

Question

Platform: developer's windows 8.1 pc with visual studio 2012 pro, .net 4.5, sql express 2012 express and localDB

in a textbox, say textTbx on a  windows form, if there is Unicode like \U2221, I have to save to file and read back without change using textTbx.Text value.

however for the content in the textTbx.Text value, upon saving to SQL Server 2012 Express LocalDB, and then retrieved, the content gets changed for some Unicode like  U2221. it get translated to the plain - instead of keeping as −.

what  parameter do I need to setup to make sure it keep such character as is?

Answer 1

Check the data type used in SQL and make sure that it is capable of handling the characters which are passed to it. you can try to use nvarchar in SQL and try it again.