On 5/9/05, Andreas Steichardt wrote: > > We are storing UTF-8 data in out mysql database and we need to get the > length > of the data. But length() doesn't return the number of characters but the > pure number of bytes.
Look at OCTET_LENGTH() and CHAR_LENGTH(). (While OCTET_LENGTH() is a synonym, it is the SQL standard way of getting the length of a string in bytes.) Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]