In SQL, in order to update Unicode values, you should add ‘N’ before the string
update [dbo].[Player]
set address1=N'aąbcćdeęfghijklłmnńoóprsśtuwyzźż',
address2=N'AĄBCĆDEĘFGHIJKLŁMNŃOÓPRSŚTUWYZŹŻ'
where alias=N'Auto77086780' or Address1=N'tägelîch'
Here an example how an update statement without this ‘N’ will update wrong value (first update),
and how the same update statement but with ‘N’ will update the correct value (second update).
(BTW - the text is in Polish.)
No comments:
Post a Comment