Re: partition with UTF8 varchar

[Jonathan Stephens]

Looks like you've uncovered a problem with ORD():

mysql> select version();
+-------------------+
| version()         |
+-------------------+
| 5.1.15-beta-debug |
+-------------------+

mysql> select ord('お');
+------------+
| ord('お') |
+------------+
|        227 |
+------------+
1 row in set (0.00 sec)

mysql> select ord('き');
+------------+
| ord('き') |
+------------+
|        227 |
+------------+
1 row in set (0.00 sec)

mysql> select ord('の');
+------------+
| ord('の') |
+------------+
|        227 |
+------------+
1 row in set (0.00 sec)

mysql> select ord('ん');
+------------+
| ord('ん') |
+------------+
|        227 |
+------------+
1 row in set (0.00 sec)

mysql> select ord('せ');
+------------+
| ord('せ') |
+------------+
|        227 |
+------------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle