set names 'latin1';
set character_set_connection = 'ucs2';
show variables like '%character%';
/*
Variable_name Value
———————— —————————————————-
character_set_client latin1
character_set_connection ucs2
character_set_database latin1
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir C:ProgrammerMySQLMySQL Server 4.1sharecharsets/
*/
set character_set_connection = 'latin1';
/*
Error Code : 1115
Unknown character set: ''
now reconnecting */
set names 'latin1';
set character_set_results = 'ucs2';
show variables like '%character%';
/* empty set
now reconnecting*/
set names 'latin1';
set character_set_client = 'ucs2';
show variables like '%character%';
/*
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show variables like '%character%'' at line 1
*/