Re: LENGTH() and UTF-8

[Jochem van Dieten]

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