开发者

sql encoding in php script

开发者 https://www.devze.com 2023-04-01 07:42 出处:网络
hey there i\'m using mysql in hebrew , but when i try to preview the sql in the page , all i see is ????? ????开发者_开发技巧? instead of my words

hey there i'm using mysql in hebrew , but when i try to preview the sql in the page , all i see is ????? ????开发者_开发技巧? instead of my words

the code i'm using is the normal SELECT

$con = mysql_connect($server,$user,$pass);
    mysql_select_db($db,$con)
    or die ("no db");
    $query="SELECT `app_desc` FROM `apps` where `id`=$id";
    $result = mysql_query($query);

and i also tried to add

mysql_set_charset('windows-1255',$con);

or this

mysql_set_charset('utf8',$con);

also when i view it in PHPmyAdmin it shows as it should.

what do i need to do ?

also the database encoding is utf8_general_ci

and page encoding is utf-8


well i'm dumb.

thanks all for your answers.

the problem is that the DB encoding was UTF-8 but the table was latin


well i'm dumb.

thanks all for your answers.

the problem is that the DB encoding was UTF-8 but the table was latin

0

精彩评论

暂无评论...
验证码 换一张
取 消