Accent problems after restore database

[vincentg38]

Hello,

I use dbForge Studio to backup a MySQL database (on a Linux server).

It create a .sql file, with correct text inside (with french accents).

In this file is a line "SET NAMES 'utf8';".

But after I restore the database with dbForge Studio, the accents in the table are wrong, looking as in ANSI (with @ inside).

Can someone help me ?

Thanks.

Vincent

[alexa]

Please select 'utf8 -> Unicode (UTF-8)' on the 'Advanced' tab of the 'Database Connection Properties' dialog box that can be opened by right-clicking the connection in Database Explorer and selecting 'Modify Connection' from the popup menu.

[vincentg38]

Many many many thanks, Alexa ! (It works perfectly now)

I was turning mad !

Vincent

[alexa]

Please let us know if any questions arise.