Access对具有unicode功能的数据类型(例如SQL Server中的nvarchar)有任何问题吗? [英] Does Access have any issues with unicode capable data types like nvarchar in SQL Server?

问题描述

我将Access 2003用作SQL Server 2008数据库的前端UI.在查看我的SQL Server数据库设计时，我想知道nvarchar是否是在varchar上使用的正确选择.我选择nvarchar是因为我认为这在需要输入由unicode表示的任何字符的情况下会很有用.但是，我没有考虑使用Unicode数据类型的Access 2003可能出现的任何问题. Access 2003在SQL Server中使用unicode数据类型(即nvarchar)是否存在任何问题?谢谢.

I am using Access 2003 as a front end UI for a SQL Server 2008 database. In looking at my SQL Server database design I am wondering if nvarchar was the right choice to use over varchar. I chose nvarchar because I thought it would be useful in case any characters represented by unicode needed to be entered. However, I didn't think about any possible issues with Access 2003 using the uni-code datatype. Are there any issues with Access 2003 working with unicode datatypes within SQL Server (i.e. nvarchar)? Thank you.

推荐答案

如果这是该作业的正确数据类型，则可以继续使用nvarchar. Access支持Unicode数据，既有自己的表，也有外部(链接的)表和直接查询.

You can go ahead and use nvarchar, if that's the correct datatype for the job. Access supports Unicode data, both with it's own tables and with external (linked) tables and direct queries.

这篇关于Access对具有unicode功能的数据类型(例如SQL Server中的nvarchar)有任何问题吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！