MySQL db question marks instead of hebrew characters..?

by

I was able to solve this by doing the following:

  1. the db collation has to be utf8_general_ci
  2. the collation of the table with hebrew has to be utf8_general_ci
  3. in your php connection script put header('Content-Type: text/html; charset=utf-8');
  4. in xhtml head tag put <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  5. after selecting the db in the connection script put mysql_query("SET NAMES 'utf8'");

More Related Contents:

  1. What is the best collation to use for MySQL with PHP? [closed]
  2. Turkish characters are not displayed correctly [duplicate]
  3. How to create this type of JSON data from PHP [closed]
  4. how to write php code for the key press enter button when fill the form?
  5. Create hyperlink from html table row to open record on a new page
  6. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  7. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  8. SELECT COUNT(*) AS count – How to use this count
  9. How to execute two mysql queries as one in PHP/MYSQL?
  10. How to upload images into MySQL database using PHP code
  11. selecting unique values from a column
  12. Create a dynamic mysql query using php variables
  13. How to enable mysqlnd for php?
  14. MySQL – Access denied for user [duplicate]
  15. Calling stored procedure with Out parameter using PDO
  16. decode a quoted printable message in php
  17. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  18. How to display an BLOB image stored in MySql database?
  19. What is the best way to insert multiple rows in PHP PDO MYSQL?
  20. How to bind LIKE values using the PDO extension?
  21. How do I set the selected item in a drop down box
  22. Fatal error: Call to undefined function mysqli_result()
  23. access denied for user @ ‘localhost’ to database ” [closed]
  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. How can I employ “if exists” for creating or dropping an index in MySQL?
  27. PHP MySQL pagination with random ordering
  28. how to execute mysql command DELIMITER
  29. How to get a list of databases?
  30. PDO and MySQL ‘between’

Leave a Comment