MySQL – length() vs char_length()

by

LENGTH() returns the length of the string measured in bytes.
CHAR_LENGTH() returns the length of the string measured in characters.

This is especially relevant for Unicode, in which most characters are encoded in two bytes. Or UTF-8, where the number of bytes varies. For example:

select length(_utf8 '€'), char_length(_utf8 '€')
--> 3, 1

As you can see the Euro sign occupies 3 bytes (it’s encoded as 0xE282AC in UTF-8) even though it’s only one character.

More Related Contents:

  1. How to convert a string to date in MySQL?
  2. How to find similar results and sort by similarity?
  3. How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
  4. How do you extract a numerical value from a string in a MySQL query?
  5. SQL order string as number
  6. How to remove all non-alpha numeric characters from a string in MySQL?
  7. How to escape single quotes in MySQL
  8. Capitalize first letter. MySQL
  9. Can MySQL replace multiple characters?
  10. How to fix double-encoded UTF8 characters (in an utf-8 table)
  11. MySql – Way to update portion of a string?
  12. mysql: why comparing a ‘string’ to 0 gives true?
  13. MySQL : how to remove double or more spaces from a string?
  14. Strip last two characters of a column in MySQL
  15. MySql Query Replace NULL with Empty String in Select
  16. Last index of a given substring in MySQL
  17. how to get result form mysql query in specific ids [closed]
  18. Why can’t this entry be added because of Foreign Key error?
  19. MySQL AUTO_INCREMENT does not ROLLBACK
  20. Create new user in MySQL and give it full access to one database
  21. MySQL automatically cast/convert a string to a number?
  22. How to select rows that have current day’s timestamp?
  23. LEFT JOIN only first row
  24. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  25. MySQL connection over SSH tunnel – how to specify other MySQL server?
  26. Storing IPv6 Addresses in MySQL
  27. How to remove constraints from my MySQL table?
  28. Get total hours worked in a day mysql
  29. Mysql How do you create a clustered index?
  30. Counting associated entries with Sequelize

Leave a Comment