Re: Problem with arabic charset

[Felipe Arias]

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT `title`, HEX(title), LENGTH(title), CHAR_LENGTH(title) FROM forum where forumid=9;
+-------------+------------------------+---------------+--------------------+
| title | HEX(title) | LENGTH(title) | CHAR_LENGTH(title) |
+-------------+------------------------+---------------+--------------------+
| ÞÓã Çá | C39EC393C3A320C387C3A1 | 11 | 6 |
+-------------+------------------------+---------------+--------------------+

mysql> alter table forum modify title tinyblob;
Query OK, 19 rows affected (0.01 sec)
Records: 19 Duplicates: 0 Warnings: 0

mysql> SELECT `title`, HEX(title), LENGTH(title), CHAR_LENGTH(title) FROM forum where forumid=9;
+-------------+------------------------+---------------+--------------------+
| title | HEX(title) | LENGTH(title) | CHAR_LENGTH(title) |
+-------------+------------------------+---------------+--------------------+
| ÞÓã Çá | C39EC393C3A320C387C3A1 | 11 | 11 |
+-------------+------------------------+---------------+--------------------+

mysql> alter table forum modify title varchar(100) charset cp1256;
Query OK, 19 rows affected (0.01 sec)
Records: 19 Duplicates: 0 Warnings: 0

mysql> SELECT `title`, HEX(title), LENGTH(title), CHAR_LENGTH(title) FROM forum where forumid=9;
+--------------------------+------------------------+---------------+--------------------+
| title | HEX(title) | LENGTH(title) | CHAR_LENGTH(title) |
+--------------------------+------------------------+---------------+--------------------+
| أأ“أ£ أ‡أ، | C39EC393C3A320C387C3A1 | 11 | 11 |
+--------------------------+------------------------+---------------+--------------------+
1 row in set



If i try cp1256 and after utf8 or inverse will be a mess. Example

أأ“أ£ أ‡أ، | D8A3E2808DD8A3E2809CD8A3C2A320D8A3E280A1D8A3D88C | 24 | 11 |

tested with column using utf8_general_ci and utf8_unicode_ci (ORIGINAL)

Using root and users with regular privileges

Maybe i'm missing something. I don't have to mess with charsets very often.