Strange characters in query results odbc

[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