Which “special” characters are allowed in SQL Server varchar fields?

• GOODS

  Ten Centuries

  Points: 1360

  More actions

  October 15, 2013 at 4:24 am

  #283891

  Hi Guys,

  I'm trying to update CompanyName Column in a table my query is very simple:

  Update dbo.CompassAD

  SET CompanyName = 'BWTS SPECIALIZED-PPC KRAAIFONTEIN'

  WHERE CompanyName = 'BWTS SPECIALIZED û PPC KRAAIFONTEIN'

  The problem is it returns no data when I execute the query and column datatype is Varchar(350).

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259085

  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 question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  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

  More actions

  October 15, 2013 at 5:34 am

  #1658470

  Latin1_General_CI_AS

• GOODS

  Ten Centuries

  Points: 1360

  More actions

  October 15, 2013 at 6:42 am

  #1658487

  Hi Koen Verbeeck

  It worked changed my datatype to nvachar..thanks a lot.