为什么sql server在NVarchar字段中存储问号字符而不是日语字符? [英] Why is sql server storing question mark characters instead of Japanese characters in NVarchar fields?

问题描述

我正在尝试将日语字符存储在我的 SQL Server 2000 数据库的 nvarchar 字段中.

I'm trying to store Japanese characters in nvarchar fields in my SQL Server 2000 database.

当我运行如下更新语句时:

When I run an update statement like:

update blah 
set address = N'スタンダードチャ'
where key_ID = 1

从 SQL Server Management Studio 运行选择语句，我只看到返回到结果窗口的问号.我在查看数据库的网页中看到了相同的问号.

from SQL Server Management Studio, then run a select statement I see only question marks returned to the results window. I'm seeing the same question marks in the webpage which looks at the database.

这似乎是存储正确数据的问题，对吗?谁能告诉我我需要做些什么不同的事情?

It seems this is an issue with storing the proper data right? Can anyone tell me what I need to do differently?

推荐答案

您需要检查处理这些数据的所有代码的全球化设置，包括您的数据库、数据访问和表示层.这包括 SSMS.

You need to check the globalisation settings of all the code that deals with this data, from your database, data access and presentation layers. This includes SSMS.

(您还需要弄清楚您使用的是哪个版本，2003 不存在...)

(You also need to work out which version you are using, 2003 doesn't exist...)

这篇关于为什么sql server在NVarchar字段中存储问号字符而不是日语字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！