Set default Unicode character string

• arturas.bernikas

  Grasshopper

  Points: 21

  More actions

  October 21, 2010 at 5:42 am

  #228132

  Hello,

  when you want to query Unicode data you need use 'N' prefix.

  For example: select * from table where column = N'Unicode_string'

  Is it possible to configure SQL Server to always use Unicode string compare?

  I mean without 'N' prefix. select * from table where column = 'Unicode_string'

• Muhammad Tariq

  Ten Centuries

  Points: 1020

  More actions

  October 21, 2010 at 7:46 am

  #1240314

  Read below article:

  http://support.microsoft.com/kb/239530/en-us

  Tariq
  master your setup, master yourself.
  http://mssqlsolutions.blogspot.com