Geek Answers Handbook

Access cannot filter Unicode characters after migrating tables to SQL Server

I migrated MS Access 2010 Data to SQL using my tools, and now Unicode filtering does not work on linked Access networks. I see a column of a linked table in SQL, it is "nvarchar", but Access has a "Unicode compression" set to "No", and I cannot change it.

+4
source share
1 answer

As I understand it, the "Unicode compression" parameter affects only native access tables (ACE / Jet) and does not affect linked ODBC tables. Instead, you probably need to change the "Collation" setting of the SQL Server database itself using SQL Server Management Studio:

DatabaseProperties.png

For example, with the SQL Server collation option above ("SQL_Latin1_General_CP1_CI_AS"), I cannot filter Greek characters (for example, "γιορτή") from Access, but if I changed the SQL Server database collation to "Greek_CI_AS", then the same access filter will be work.

Edit re: comments

, SQL Server (, , Windows-1253), , ,

  • , SQL Server,
  • Unicode.

ODBC Access, -, Unicode, SQL Server 'text', N'text', SQL Server ( "" ).

+3

More articles:


All Articles