Characters like ë, ô, etc.

General usage of Access to MySQL

Moderator: jr

Characters like ë, ô, etc.

Postby theosmeets » Fri Oct 01, 2010 11:59 am

I did not find any answers on questions put at the forum about, what I call, "strange characters" (spanish, russian, etc). Does anybody know how to deal with this problem in Access to mySQL ? Thank you very much !!!
theosmeets
 
Posts: 1
Joined: Fri Oct 01, 2010 11:48 am

Re: Characters like ë, ô, etc.

Postby jr » Sun Oct 03, 2010 8:12 pm

Have you tried to select the Unicode feature on the last page of the wizard?

regards,
Jacob
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm

Re: Characters like ë, ô, etc.

Postby nolaflash » Fri Apr 15, 2011 8:33 pm

I am wondering about this as well. I have tried the Unicode feature but find that I still get "Vieux Carré" instead of "Vieux Carré". Anyone know of a solution?
nolaflash
 
Posts: 3
Joined: Fri Apr 15, 2011 8:24 pm

Re: Characters like ë, ô, etc.

Postby lambertwm » Mon Sep 26, 2011 10:45 am

In fact, the text file that "Access to MYSQL" generates is correctly coded in UTF-8 and it contains all the correct accents.

You can check this by opening it in Notepad (maybe you need to specify the encoding in the File Open dialog).

I think your problem is that you didn't specify the correct character set when running the generated script.

This should do the trick:

1. Open a dos box
2. make sure mysql.exe is in your PATH
3. run the following command:

mysql --password=root --user=root --default_character_set=utf8 < dump.sql

This assumes the SQL statements are in a file called 'dump.sql'

hope this helps,
lambertwm
 
Posts: 1
Joined: Mon Sep 26, 2011 10:30 am


Return to General

Who is online

Users browsing this forum: No registered users and 3 guests