how to update nvarchar using variable

• markort

  SSC Veteran

  Points: 212

  More actions

  July 8, 2010 at 5:02 pm

  #223631

  How do I update nvarchar with foreign characters using variable?

  This works:

  update MyTable set col1 = N'ČDĎÉĚ'

  this does not:

  declare @a nvarchar(20)

  set @a = 'ČDĎÉĚ'

  update MyTable set col1 = N'@a

  Thank you

• SwedishOrr

  SSCrazy

  Points: 2955

  More actions

  July 8, 2010 at 5:13 pm

  #1190559

  Hey There,

  The following worked for me:

  declare @a nvarchar(20)

  set @a = N'CDDÉE'

  update testcols set col1 = @a

  HTH

• markort

  SSC Veteran

  Points: 212

  More actions

  July 9, 2010 at 9:28 am

  #1190876

  It works. Thanks again.