What is the best collation to use for MySQL with PHP? [closed]

by

The main difference is sorting accuracy (when comparing characters in the language) and performance. The only special one is utf8_bin which is for comparing characters in binary format.

utf8_general_ci is somewhat faster than utf8_unicode_ci, but less accurate (for sorting). The specific language utf8 encoding (such as utf8_swedish_ci) contain additional language rules that make them the most accurate to sort for those languages. Most of the time I use utf8_unicode_ci (I prefer accuracy to small performance improvements), unless I have a good reason to prefer a specific language.

You can read more on specific unicode character sets on the MySQL manual – http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html

More Related Contents:

  1. MySQL db question marks instead of hebrew characters..?
  2. Turkish characters are not displayed correctly [duplicate]
  3. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  4. php+mysql Fatal error: Call to undefined function mysql_connect()
  5. Using PHP data in MySQL [closed]
  6. drop down menu using php and mysql [closed]
  7. php code for multiple search box after connecting to mysql [closed]
  8. Checking the availability of rooms
  9. How to sort user data by id
  10. PHP PDO prepared statements
  11. Example of how to use bind_result vs get_result
  12. mysqli::query(): Couldn’t fetch mysqli
  13. Levenshtein: MySQL + PHP
  14. Incorrect Integer (2147483647) is inserted into MySQL?
  15. PHP date() format when inserting into datetime in MySQL
  16. convert php date to mysql format
  17. Special characters in PHP / MySQL
  18. Fetching single row, single column with PDO
  19. IP address storing in MySQL database using PHP [duplicate]
  20. “No such file or directory” or “No such host is known” when running migrations
  21. Select last 20 order by ascending – PHP/MySQL
  22. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  23. How to backup MySQL database in PHP?
  24. Create PHP array from MySQL column
  25. UNION syntax in Cakephp
  26. How do i search from serialize field in mysql database?
  27. Group mysql results by category and display them into groups under each category
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment