Storing and displaying unicode string using PHP and MySQL

Question

I have to store hindi text in a MySQL database  fetch it using a PHP script and display it on a webpage  I did the following   I created a database and set its encoding to UTF-8 and also the collation to utf8 bin   I added a varchar field in the table and set it to accept UTF-8 text in the charset property   Then I set about adding data to it  Here I had to copy data from an existing site  The hindi text looks like this            05 30   I directly copied this text into my database and used the PHP code echo utf8 encode  string   to display the data  Upon doing so the browser showed me            When I inserted the UTF equivalent of the text by going to  view source  in the browser  however           translates into  amp  2360  amp  2370  amp  2352  amp  2381  amp  2351  amp  2379  amp  2342  amp  2351    If I enter and store  amp  2360  amp  2370  amp  2352  amp  2381  amp  2351  amp  2379  amp  2342  amp  2351  in the database  it converts perfectly   So what I want to know is how I can directly store          into my database and fetch it and display it in my webpage using PHP   Also  can anyone help me understand if there s a script which when I type in           gives me  amp  2360  amp  2370  amp  2352  amp  2381  amp  2351  amp  2379  amp  2342  amp  2351    Solution Found  I wrote the following sample script which worked for me  Hope it helps someone else too   lt html gt     lt head gt       lt title gt Hindi lt  title gt  lt  head gt     lt body gt       lt  php       include  connection php      simple connection setting        result   mysql query  SET NAMES utf8      the main trick        cmd    select   from hindi          result   mysql query  cmd         while   myrow   mysql fetch row  result                     echo   myrow 0                  gt     lt  body gt   lt  html gt    The dump for my database storing hindi utf strings is  CREATE TABLE  hindi       data  varchar 1000  character set utf8 collate utf8 bin default NULL   ENGINE InnoDB DEFAULT CHARSET latin1   INSERT INTO  hindi  VALUES                 Now my question is  how did it work without specifying  META  or header info   Thanks

User · Answer

For those who are looking for PHP    5 3 5   PDO statement  we can set charset as per below    dbh   new PDO  mysql host localhost dbname testdb charset utf8    username    password

User · Answer

lt meta http-equiv  Content-Type  content  text html charset UTF-8  gt     lt  php   con   mysql connect  localhost   root       if    con        die  Could not connect      mysql error          mysql query  SET character set results utf8    mysql query  SET names utf8    mysql query  SET character set client utf8    mysql query  SET character set connection utf8    mysql query  SET character set results utf8    mysql query  SET collation connection utf8 general ci     mysql select db  onlinetest   con     nith    CREATE TABLE IF NOT EXISTS  TAMIL       data  varchar 1000  character set utf8 collate utf8 bin default NULL   ENGINE InnoDB DEFAULT CHARSET latin1    if   mysql query  nith  con       die  Error      mysql error         nithi    INSERT INTO  TAMIL  VALUES                                   if   mysql query  nithi  con       die  Error      mysql error         result   mysql query  SET NAMES utf8     the main trick  cmd    select   from TAMIL    result   mysql query  cmd   while  myrow   mysql fetch row  result         echo   myrow 0        gt   lt  body gt   lt  html gt

User · Answer

For Those who are facing difficulty just got to php admin and change collation to utf8 general ci Select Table go to Operations   table options   collations should be there

User · Answer

Did you set proper charset in the HTML Head section    lt meta http-equiv  Content-Type  content  text html charset UTF-8  gt    or you can set content type in your php script using -      header   Content-Type  text html  charset utf-8        There are already some discussions here on StackOverflow - please have a look  How to make MySQL handle UTF-8 properly setting utf8 with mysql through php  PHP MySQL with encoding problems     So what i want to know is how can i   directly store          into my   database and fetch it and display in   my webpage using PHP    I am not sure what you mean by  directly storing in the database     did you mean entering data using PhpMyAdmin or any other similar tool  If yes  I have tried using PhpMyAdmin to input unicode data  so it has worked fine for me - You could try inputting data using phpmyadmin and retrieve it using a php script to confirm  If you need to submit data via a Php script just set the NAMES and CHARACTER SET when you create mysql connection  before execute insert queries  and when you select data  Have a look at the above posts to find the syntax  Hope it helps      UPDATE    Just fixed some typos etc

User · Answer

CREATE DATABASE hindi test CHARACTER SET utf8 COLLATE utf8 unicode ci  USE hindi test  CREATE TABLE  hindi    data  varchar 200  COLLATE utf8 unicode ci NOT NULL  ENGINE InnoDB DEFAULT CHARSET utf8 COLLATE utf8 unicode ci  INSERT INTO  hindi    data   VALUES

[php] Storing and displaying unicode string (??????) using PHP and MySQL

Examples related to php

Examples related to mysql

Examples related to unicode

Examples related to utf-8

Examples related to internationalization