MySQL db question marks instead of hebrew characters..?

Question

I'm trying to build a shopping cart using PHP & MySQL. my db in MySQL is utf8 and my table in the db is utf8,

How can I use Hebrew characters?

http://stackoverflow.com/questions/4571044/problem-with-hebrew-mysql-c — bensiu, Mar 13 '11 at 06:10
possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Peter O., Apr 21 '15 at 09:23

score 19 · Answer 1 · edited Mar 15 '11 at 05:21

19

I was able to solve this by doing the following:

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

edited Mar 15 '11 at 05:21

Brad Mace

27,194
17
102
148

answered Mar 14 '11 at 08:13

amir

191
2

1

Glad you figured it out. Could you mark this thread as solved? – Ted Hopp Mar 14 '11 at 22:40
Just a heads up, the `mysql_query("SET NAMES 'utf8'");` is to be entered _as is_. – Advait Saravade May 02 '16 at 18:08
PDO version: $dbh->query("SET NAMES 'utf8'"); – Idan Magled Aug 26 '16 at 15:48

score 6 · Answer 2 · edited Jun 01 '11 at 12:40

After a lot of work I found a solution that always works..: without SET_NAMES.

In the conn.inc.php file, after you selected a database and connected to it, do this:

if(!mysqli_set_charset($conn, 'utf8')) {
    echo 'the connection is not in utf8';
    exit();
}

...and in the html always use charset utf-8;

That solved it for me. No need to use set_names(), which is ok but it annoyed the hell out of me.

Jannie Theunissen · Answer 3 · 2016-01-01T08:42:06.820

5

You can use the PDO in your code like this:

 $db = new PDO($config['DSN'], $config['dbUserName'], $config['dbPassword']);
 $db->exec("SET NAMES 'utf8'");

Make sure you include the single quotation marks around the 'utf8'.

edited Jan 01 '16 at 08:42

answered May 31 '11 at 18:45

Jannie Theunissen

28,256
21
100
127

score 3 · Answer 4 · answered Mar 13 '11 at 06:11

3

If it's an encoding problem (and it sounds like it is), this query will help:

SET NAMES utf8

Execute this query (e.g. mysql_query("SET NAMES utf8")) right after you connect and before you move any data.

More info

answered Mar 13 '11 at 06:11

awm

6,526
25
24

where do i need to execute it? i tried to execute it in phpMyAdmin in my db under query it returned with syntax error.... i tried putting ; at the end of the query it won't work... i think the problem is with MySQL stuff cause when i echo something in php i can see hebrew.... – Amir Mar 13 '11 at 08:17
ok i tried putting mysql_query("SET NAMES utf8"); in my php code it won't work and i tried putting the query to mysql query in phpMyAdmin and still i can't see hebrew characters. this guy in here got it to work but i don't know where he put the codes... http://www.webmasterworld.com/php/3553642.htm – Amir Mar 13 '11 at 09:37

score 2 · Answer 5 · answered Apr 27 '16 at 17:36

2

$conn->set_charset("utf8"); Use this for your dbconnect

answered Apr 27 '16 at 17:36

allpnay

539
6
19

score 1 · Answer 6 · edited Jun 19 '12 at 11:05

To store non-ASCII characters in a database column, you need to define that column with a specific character set. You can specify a character set at 3 levels: database, table, and column. For example:

CREATE DATABASE db_name CHARACTER SET utf8
CREATE TABLE tbl_name (...) CHARACTER SET utf8
CREATE TABLE tbl_name (col_name CHAR(80) CHARACTER SET utf8, ...)

http://www.herongyang.com/PHP/Non-ASCII-MySQL-Store-Non-ASCII-Character-in-Database.html

score 1 · Answer 7 · answered Mar 13 '11 at 06:10

1

Where are the question marks showing up? It may be an encoding problem somewhere other than in the data base.

answered Mar 13 '11 at 06:10

Ted Hopp

232,168
48
399
521

The HTML needs to be generated with an encoding that supports Hebrew (or else the Hebrew characters need to be properly escaped in the HTML). The browser also needs to know what encoding was used (usually through an HTTP header and/or a META tag). It could still be a data base problem, but there are a lot of other places in the path between the data in the data base and the browser display that could be the source of the problem. – Ted Hopp Mar 13 '11 at 16:38
thanks ted, but i tried that allready.... when i right click in firefox and selects page info it show that my page uses utf8 but still i see question marks instead of hebrew character's also i have a utf-8 meta tag in my html and lang=he in my header tag. is there any other suggestions?... – Amir Mar 13 '11 at 16:45
Make sure that UTF-8 is being used in the code that generates the HTML. Try exercising that code with some hard-coded Hebrew (that doesn't come from the db) to confirm that the problem is in what's coming out of the db. – Ted Hopp Mar 13 '11 at 20:31
tried that... for 8 hours i'm trying to see hebrew character's.... when i echo something using php in hebrew i can see hebrew when i write something in hebrew let's say in a h1 tag i can see hebrew that's why i think the problem is in MySQL db... any other suggestion cause i tried all the suggestion u guys gave me but no luck what so ever. thanks in advance. – Amir Mar 13 '11 at 21:42

score 0 · Answer 8 · answered Mar 24 '18 at 00:30

0

In my case I created the DB from a dump, and this command solve it:

ALTER DATABASE <database_name> CHARACTER SET utf8 COLLATE utf8_unicode_ci;

answered Mar 24 '18 at 00:30

Idan Magled

2,186
1
23
33

score -1 · Answer 9 · edited Jan 15 '15 at 23:39

-1

mysql_query('SET NAMES utf8') ..... Put this in Php

edited Jan 15 '15 at 23:39

greatwolf

20,287
13
71
105

answered Jan 15 '15 at 21:13

Ali Al-eboody

25
8

MySQL db question marks instead of hebrew characters..?

9 Answers9

Linked

Related