tisdag 11 september 2012

SQL Server: Update expression when new value is a string with an accented character

If we want to update a string value and the new value has accented characters (e.g. č) one way to accomplish this is, in the SQL expression, to prefix the value with a capital letter 'n'.
For example like so:
UPDATE DB.table
SET Column = N'Količina'
WHERE Id = x

Inga kommentarer:

Skicka en kommentar