Koen Verbeeck
SSC Guru
Points: 259197
More actions
October 15, 2013 at 4:40 am
#1658454
Maybe you should use unicode? (the nvarchar data type)
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
MarkusB
SSC-Dedicated
Points: 37370
October 15, 2013 at 4:58 am
#1658458
To answer your question in the subject header, it depends on your collation. Each collation contains some special varchar characters, but they vary.
What is the collation of your column?
[font="Verdana"]Markus Bohse[/font]
GOODS
Ten Centuries
Points: 1360
October 15, 2013 at 5:34 am
#1658470
Latin1_General_CI_AS
October 15, 2013 at 6:42 am
#1658487
Hi Koen Verbeeck
It worked changed my datatype to nvachar..thanks a lot.
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply