Problem tested using both version 4.0.18 and 4.1.1
This query gets first byte of utf8 character, not two bytes
If I use
SELECT LEFT(FieldName, 2) AS FirstLetter, COUNT(*) FROM TableName GROUP BY
FirstLetter
gets right utf8 characters but others wrong
for example;
++---+
| Ai
Hi,
I need this query;
SELECT LEFT(FieldName, 1) AS FirstLetter, COUNT(*) FROM TableName GROUP BY FirstLetter
my datas in utf8 format. I can't get first characters of the datas in utf8 format but
others is ok.
Any suggestion?
Thank you
