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

  • GOODS

    Ten Centuries

    Points: 1360

    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: 258909

    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: 37369

    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

    Latin1_General_CI_AS

  • GOODS

    Ten Centuries

    Points: 1360

    Hi Koen Verbeeck

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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply