PROTECTED]
Sent: Saturday, March 13, 2004 5:34 AM
Subject: re: utf8 - left function
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
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;
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
It works for me. I'm using the development