如何在MS sql结果网格中显示unicode数据. [英] How to display unicode data in MS sql result grid.

问题描述

我的数据库中有包含unicode数据的行.选择这些数据后，其显示类似于box([]).如果要在MS sql结果网格中以正确格式查看unicode数据，该怎么办.

I have rows with unicode data in my database. after selecting those data its shows like boxes([]). what to do if we want to view unicode data in correct format in MS sql result grid.

推荐答案

您好，
您应该使用"N"前缀.
这表示后面的字符串是Unicode(N实际上代表本国语言字符集).这意味着您正在传递NCHAR，NVARCHAR或NTEXT值，而不是CHAR，VARCHAR或TEXT.


例如:

Hi there,
You should use a ''N'' prefix.
This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or NTEXT value, as opposed to CHAR, VARCHAR or TEXT.


for example:

INSERT INTO ... VALUES (N''String'',N''String'';...
UPDATE ... SET ...=N''String''...WHERE ...=N''String''
SELECT ... FROM ... WHERE ...=N''String''.

这篇关于如何在MS sql结果网格中显示unicode数据.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！