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.
views:
26answers:
1
+1
A:
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.
mdma
2010-06-17 17:37:46
+1 Access 2000 and later use Unicode for text, memo, and hyperlink fields. And when upsizing a Jet table to SQL Server, the Upsizing Wizard creates an nvarchar field for a Jet text field. nvarchar as "correct datatype for the job" seems right to me.
HansUp
2010-06-17 18:10:52
Excellent ... thank you!
webworm
2010-06-17 18:20:06