Charset Latin 1

[peterlaursen]

BTW:

I think we will see more charset options in the connections manager for the future.

I request a TAB in preferences where users can check which ones should be displayed in connections manager. Most users will only need a few!

[peterlaursen]

Now it is not reproducable with MySQL command-line:

Code:

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 43 to server version: 5.0.19-nt-max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use test;
Database changed
mysql> select * from t1;
Empty set (0.00 sec)

mysql> show variables like '%character%';
+————————–+——————————————————+
| Variable_name | Value |
+————————–+——————————————————+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:programmermysqlMySQL Server 5.0sharecharsets |
+————————–+——————————————————+
8 rows in set (0.00 sec)

mysql> insert into t1 values (1,'æøå');
Query OK, 1 row affected (0.03 sec)

mysql> select * from t1;
+—-+——+
| id | t |
+—-+——+
| 1 | æøå |
+—-+——+
1 row in set (0.00 sec)

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 45 to server version: 5.0.19-nt-max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show variables like '%character%';
+————————–+——————————————————+
| Variable_name | Value |
+————————–+——————————————————+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:programmermysqlMySQL Server 5.0sharecharsets |
+————————–+——————————————————+
8 rows in set (0.00 sec)

mysql> Set character_set_connection=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> Set character_set_client=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> Set character_set_results=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> use test;
Database changed

mysql> select * from t1;
+—-+——+
| id | t |
+—-+——+
| 1 | æøå |
+—-+——+
1 row in set (0.00 sec)

Does this not look like an issue with the API ?

[peterlaursen]

This issue is no longer reproducable with SQLyog 5.1 BETA 4.

What fixed it ?

[Ritesh]

Couple of bug fixes regarding charsets. This area is still under development and expect some more fine tuning in coming BETAs.

[Author]

Posts