Obviously Does Not Work ..

[peterlaursen]

See attached

Of course SQLyog cannot use ucs2 for the connection at all!

MySQL does not understand those 7 2-byte characters (sh-ow- d-at-ab-as-es) that SQLyog sends!

ucs2 should be removed as an option from the connections manager with next build!

[Ritesh]

Added for v5.14.

[peterlaursen]

It has worked before!

Now some 5.1.x versions have used 'set names' others 'set character_set_connection'

As long as the client code does not support multibyte chars I think it should only

'set character_set_connection' and NOT 'set names'

I think this illustrates this:

Code:

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
*/

[Author]

Posts