On Monday 09 May 2005 12:24, John Doe wrote:
> Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt:
> > Hi!
> >
> > 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 byte
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
synon
Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt:
> Hi!
>
> 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.
>
> SELECT LENGTH('köter') => 6
>
> Currently we are d
