在MS-SQL-Server上的INSERT语句中更改UTF-8字符

I have a table on my MS-SQL-Server 2008R2 that itself has an nvarchar(50) field.

我的MS-SQL-Server 2008R2上有一个表，它本身有一个nvarchar（50）字段。

Now when i insert a value using the Server Management Studio like

现在当我使用Server Management Studio插入一个值时

INSERT INTO INFORMATIONS(SOME_TEXT) VALUES('finančné služby')

and i immediately select the value

我立即选择了该值

SELECT SOME_TEXT FROM INFORMATIONS

i get

我明白了

financné služby

So the čdoes get converted into a plain c while the ž is handled just fine.

所以čdoes被转换成普通c，而ž处理得很好。

What am I missing here?

我在这里想念的是什么？

The collation is set to Latin1_General_CI_AS if that is of any help.

如果有任何帮助，则排序规则设置为Latin1_General_CI_AS。

1 个解决方案

#1

Prefix your values with N while inserting.

插入时用N前缀值。

INSERT INTO INFORMATIONS(SOME_TEXT) VALUES(N'finančné služby')

CHECK SQL FIDDLE DEMO

检查SQL FIDDLE DEMO