Here You are OVERALL solution for 4.1 that makes Your php (for example) code 'crosshosted' i.e. it will not depend on MySQL server charset options (it's very useful when host admin is not available :) ) :
After connecting (@mysql_connect) and selecting (@mysql_select_db) a database You should make the following:
$set = @mysql_query ('SET NAMES CP1251');
$set = @mysql_query ('SET COLLATION_CONNECTION=CP1251_GENERAL_CI');
may be just first SET is enough even.
Remove ANY stuff concerning charsets from my.ini (my.cnf) just forget it and set connection properties as above. Some stupid strings from errors.log will gone as bonus :)"
For Thai charset, see below.
set names tis620
It works very well with ODBC 3.51 on VS.NET 2003.