I have a problem with character set client and connection in MySQL 4.1.10. I have all tables in cp1250_czech_cs collation and I have set a global session character_set_client, character_set_connection and character_set_result to cp1250. When I make a connection to the database in PHP (mysqli_connect() and execute a query SHOW SESSION VARIABLES; it return that character_set_client, character_set_connection and character_set_client is set to latin1.
What can I do, when I want to set this variables to cp1250 as default? (and not use SET NAMES cp1250; in each script).
My OS is Win XP SP2 and Win 2000, Mysql version 4.1.10-nt, PHP version 5.0.3
Thanks.
What can I do, when I want to set this variables to cp1250 as default? (and not use SET NAMES cp1250; in each script).
My OS is Win XP SP2 and Win 2000, Mysql version 4.1.10-nt, PHP version 5.0.3
Thanks.