mysql query doesn't work when from the php page when are in other language (hebrew)

Asked Feb 23 '15 at 16:41

Active Feb 23 '15 at 16:41

Viewed 23 times

My code is

<$php
$database = new mysqli("127.0.0.1", "root", "root", "picture");
$new_album = "CREATE TABLE `נסיון` ("
    . "id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,"
    . "pic VARCHAR(20) NOT NULL,"
    . "des VARCHAR (40) )";
$database->query($new_album);
?>

but if i copy the query as

CREATE TABLE `ש` (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pic VARCHAR(20) NOT NULL,des VARCHAR (40)
)

strait into the phpMyAdmin query segmant, it creates the table with the hebrew currect.

in the head tag, there is a <meta charset="windows-1255"/> which is working when i print or echo anything in hebrew.is there anything else i could change in the page settings to fix this?

asked Feb 23 '15 at 16:41

פז הרשברג

having an html charset header is utterly meaning less. your html has absolutely NOTHING to do with the php->mysql connection. – Marc B Feb 23 '15 at 16:44
so what do i do to fix it? – פז הרשברג Feb 23 '15 at 16:50
before $new_album variable, add mysql_set_charset('utf8',$database); – kasparg Feb 23 '15 at 17:37

mysql query doesn't work when from the php page when are in other language (hebrew)

0 Answers0