Share via

UTF-8 support in Access

Anonymous
2013-05-24T22:41:32+00:00

I am trying to figure out why data with french accents is not being saved in my table. Any help would be appreciated... :0)

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-05-27T14:19:37+00:00

    Thank You for the response. I tried using a new database and as you have indicated it works just fine.

    My mistake in not providing the correct and/or complete detail. I am using Access to retrieve data from a Production database (Oracle) via ODBC and that's where I don't see (e + acute). However, when I query the Production database using RazorSQL tool the data does contain the (e + acute). I am guessing it may be the ODBC, but have no idea.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-05-25T12:53:43+00:00

    I can confirm Tom's affirmation since I do a lot of work in French and have never had any issues and have my client's installation using default settings (so it works fine out of the box).

    A couple ideas:

    • Compact and repair
    • Ensure MS Access is up-to-date (SP)
    • Create a new blank database and import everything and see if it works and better

    Also,  if you make an entry directly in the table, does it work?  (Basically, is it a form or table issue?)

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2013-05-25T04:32:02+00:00

    Starting with Office 2000 Access is using Unicode under the covers, so it should save your French accents. I used the Northwind application and was able to use é (e + acute) just fine.

    Was this answer helpful?

    0 comments