Does MySQL Regexp support Unicode matching

by

  1. Does anyone know if Mysql’s regexp supports unicode? I’ve been doing some research and the majority of blogs etc. seem to indicate that there is a problem or its not supported.

    As documented under Regular Expressions:

    Warning

    The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multi-byte safe and may produce unexpected results with multi-byte character sets. In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal.

  2. I’m wondering then is it best to use LIKE for unicode pattern matching and regexp for ASCII enhanced pattern matching?

    Yes, that would be best.

  3. I Like the idea of being able to search for matches at the beginning or end of a string, but if regexp doesn’t support unicode then this could be difficult if my text is unicode.

    One can do that with LIKE too:

    WHERE foo LIKE 'bar%'

    And:

    WHERE foo LIKE '%bar'

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. How to do a regular expression replace in MySQL?
  3. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  4. How to display UTF-8 characters in phpMyAdmin?
  5. MySQL Split Comma Separated String Into Temp Table
  6. MySQL strip non-numeric characters to compare
  7. How to extract two consecutive digits from a text field in MySQL?
  8. How to extract the nth word and count word occurrences in a MySQL string?
  9. How to remove all non-alpha numeric characters from a string in MySQL?
  10. How to count words in MySQL / regular expression replacer?
  11. How to store unicode in MySQL?
  12. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  13. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  14. MySQL VARCHAR Lengths and UTF-8
  15. MySQL treats ÅÄÖ as AAO?
  16. How do I refer to capture groups in a MySQL regex?
  17. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  18. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  19. How to regex in a MySQL query
  20. MySQL matching unicode characters with ascii version
  21. remove all numeric characters from column mysql
  22. MySQL: Querying for unicode entities
  23. mySQL regex in the where clause
  24. MySQL – Get row number on select
  25. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  26. Best practices for SQL varchar column length [closed]
  27. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  28. RMySQL dbWriteTable with field.types
  29. MySQL throws Incorrect string value error
  30. ORDER BY alphabet first then follow by number

Leave a Comment