> 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 source 4.1.2. Maybe the problem has already been fixed. You are using a 4.1.x version, right? It definitely would not work before 4.1. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
