List:General Discussion« Previous MessageNext Message »
From:Jochem van Dieten Date:May 9 2005 10:58am
Subject:Re: LENGTH() and UTF-8
View as plain text  
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
Thread
LENGTH() and UTF-8Andreas Steichardt9 May
  • Re: LENGTH() and UTF-8John Doe9 May
    • Re: LENGTH() and UTF-8Andreas Steichardt9 May
  • Re: LENGTH() and UTF-8Jochem van Dieten9 May