Re: odbc can not get the whole utf8 string

[cole lin]

I think it is not because f2 too small;
varchar(25) means can store 25 character but not 25 byte；

I can operate with:
mysql -h 192.168.26.42 -u root -p

mysql> insert into test_tab values(2, "沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙");
Query OK, 1 row affected (0.02 sec)

mysql> select f2 from test_tab where f1 = 2;
+-----------------------------------------------------------------------------+
| f2 |
+-----------------------------------------------------------------------------+
| 沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙子沙 |
+-----------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select length(f2),char_length(f2) from test_tab where f1 = 2;
+------------+-----------------+
| length(f2) | char_length(f2) |
+------------+-----------------+
| 75 | 25 |
+------------+-----------------+
1 row in set (0.00 sec)