php - Stored non-English characters, got '?????' - MySQL Character Set issue -

-

my site working on in farsi , text being displayed ????? (question marks). changed collation of db tables utf8_general_ci still shows ???

i ran following script change tables did not work well.

i want know doing wrong

<?php // connection mysql_connect("mysql.ord1-1.websitesettings.com","user_name","pass"); mysql_select_db("895923_masihiat");  // convert code $res = mysql_query("show tables"); while ($row = mysql_fetch_array($res)) {     foreach ($row $key => $table)     {         mysql_query("alter table " . $table . " convert character set utf8 collate utf8_unicode_ci");         echo $key . " =&gt; " . $table . " converted<br />";     } } ?>

bad news. first, double check:

select col, hex(col)...

to see in table. if hex shows 3f, data gone. correctly stored, dal character should hex d8af; hah hex d8ad.

what happened:

  • you had utf8-encoded data (good)
  • set names latin1 in effect (default, wrong)
  • the column declared character set latin1 (default, wrong)

as inserted data, converted latin1, not have values farsi characters, question marks replaced them.

the cure (for future `inserts):

  • recode application using mysqli_* interface instead of deprecated mysql_* interface.
  • utf8-encoded data (good)
  • mysqli_set_charset('utf8')
  • check column(s) and/or table default character set utf8
  • if displaying on web page, <meta...utf8> should near top.

the discussion above character set, encoding of characters. tip on collation, used comparing , sorting.

if want these treated equal: 'بِسْمِ' = 'بسم', use utf8_unicode_ci (instead of utf8_general_ci) collation.


Comments

Post a Comment

Popular posts from this blog

java - Ebean enhancement ignores a model -

-
we using avaje-agentloader enhance our ebeans. ebeans in same package. including loader, agent & base ebean library in our project (via sbt): "org.avaje" % "avaje-agentloader" % "1.1.2", "org.avaje.ebeanorm" % "avaje-ebeanorm" % "4.5.5", "org.avaje.ebeanorm" % "avaje-ebeanorm-agent" % "4.5.2", however, when loader runs enhancement, skips 1 ebean. each ebean annotated @entity , extends com.avaje.ebean.model . there seem no differences between ones enhanced , 1 not. there no includes, or extends, etc. basically, i'm wondering if has run across issue in past, or has insights. things we've tried: specifying actual classes enhanced via serverconfig.setclasses(...) specifying pakages analyse/enhance via serverconfig.addpackage(...) or setpackages(...) not specifying @ , having loader analyse all. we've set break-point @ transformer.transform , bean in questio...
Read more

ubuntu - How to disable Kernel Module Signing in linux -

-
i'm working real time scheduler developed @ university , when run "module verification failed: signature and/or required key missing - tainting kernel". i've learned might because of kernel module signing. possible dissable on ubuntu? i'm using ubuntu vmplayer. module signing enabled within kernel configuration file starting kernel version 3.7, can disable running make menuconfig within kernel source directory , deselecting module signature verification option within enable loadable kernel module menu option. after have recompile kernel.
Read more

SQL php on different pages to Insert (mysqli) -

-
i have piece of php code, works when placed on index page ( index.php ), nothing if put in page, i.e. add.php for example: having code add.php page, tried go to: www.myhost.com/add.php , nothing happen. if copy code index.php , go page www.myhost.com/index.php add row in sql table. why that? <?php $server="mysql.server.com"; $user="randomusr"; $pass="randompwd"; $db="randomdb"; $link=mysqli_connect($server, $user, $pass, $db); $result=mysqli_query($link,"select * `battery` `id`"); $query = "insert battery (id,type,owner,charge,time) values ('1','lily002','maisnow','15','2015-04-22 17:20:28')"; mysqli_query($link, $query); header("location: index.php"); //this 1 comment out when copied index.php ?> l # name type collation attributes null 1 id int(16) no ...
Read more