Save Accents in MySQL Database

by

Personally I solved the same issue by adding after the MySQL connection code:

mysql_set_charset("utf8");

or for mysqli:

mysqli_set_charset($conn, "utf8");

or the mysqli OOP equivalent:

$conn->set_charset("utf8");

And sometimes you’ll have to define the main php charset by adding this code:

mb_internal_encoding('UTF-8');

On the client HTML side you have to add the following header data :

<meta http-equiv="Content-type" content="text/html;charset=utf-8" />

In order to use JSON AJAX results (e.g. by using jQuery), you should define the header by adding :

header("Content-type: application/json;charset=utf8");
json_encode(
     some_data
);

This should do the trick

More Related Contents:

  1. strange character encoding of stored data , old script is showing them fine new one doesn’t
  2. Convert latin1 characters on a UTF8 table into UTF8
  3. PDO + MySQL and broken UTF-8 encoding
  4. Can’t insert Chinese character into MySQL
  5. MySQL diacritic insensitive search (spanish accents)
  6. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  7. UTF-8 character encoding battles json_encode() [duplicate]
  8. UTF-8 not working in HTML forms
  9. How to get the value which user has selected in php?
  10. Organization db for blog posts with Mysql and Php [closed]
  11. mysqli or PDO – what are the pros and cons? [closed]
  12. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  13. How to resolve ambiguous column names when retrieving results?
  14. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  15. The holy grail of cleaning input and output in php?
  16. MySQL: Select Random Entry, but Weight Towards Certain Entries
  17. MySQL – Access denied for user [duplicate]
  18. Calling stored procedure with Out parameter using PDO
  19. When *not* to use prepared statements?
  20. How to display an BLOB image stored in MySql database?
  21. How to handle diacritics (accents) when rewriting ‘pretty URLs’
  22. How to bind LIKE values using the PDO extension?
  23. How do I set the selected item in a drop down box
  24. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  25. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  26. PHP 7 RC3: How to install missing MySQL PDO
  27. PHP MySQL pagination with random ordering
  28. mysql_connect VS mysql_pconnect [closed]
  29. Strange problem with the length of the field gotten from database [duplicate]
  30. mysql_fetch_array skipping first row

Leave a Comment