CODEWITHSUNDEEP
ms-accessms-access-2007ms-access-2010
saikri
saikri

Reputation: 157

Creating an Access database with a specific encoding scheme

Can I create an Access database with a specific encoding scheme like UTF-8, ANSI, or Greek? If I don't specify an encoding scheme what will Access use?

Upvotes: 0

Views: 95

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123619

Current versions of Access will always store text internally as Unicode, so there is no way to create an Access database that uses a particular character set.

However, Access does offer the option to create databases that use different sort orders (collation sequences) for different languages, e.g., Greek, Italian, Russian, etc.. For more information see

Specify the default language sort order

Upvotes: 1

Related Questions