Strange characters in query results odbc

[eluser]Nacho[/eluser]
Hi, I have a problem and not know how I can fix it.
When I perform a query to an MS Access database using the odbc driver and there are international characters, the result shows a strange symbol ... a black square with a question mark.
For example, if a result is Federatión, which is displayed is Federati?n(ó => black box with question mark).

In the configuration file database.php tried changing

Code:

$ db ['default'] ['char_set'] = 'utf8';
$ db ['default'] ['dbcollat​​'] = 'utf8_general_ci';

For

Code:

$ db ['simon'] ['char_set'] = 'latin1';
$ db ['simon'] ['dbcollat​​'] = 'latin1_swedish_ci';

But does not solve the problem.

I also tried using the function array_walk, but could not make it work ...

Anyone can help me?

Thank you very much and sorry for my English!

[eluser]InsiteFX[/eluser]
Check your database table collation and also what the databse collation is set!

MySQL will default to latin1_swedish_ci if you do not set it correct!

You can check this with phpMyAdmin by clicking on your database name then operations tab and look at the bottom and see what the database collation is set to, you can see the table collation by opening any table.

InsiteFX

[eluser]Nacho[/eluser]
This problem I have it with a database of MS Access (. mdb).
Known way to do it in this database?

Thanks for your reply!

[eluser]InsiteFX[/eluser]
Ya, Sorry about that!

I have not used access in years.

I still have the 2007 version but its not installed

InsiteFX

[eluser]Nacho[/eluser]
Anyone think of a possible solution?
Thanks!