« previous next »
Pages: [1]

Author Topic: [SOLVED] Storing "Non-English" characters under MySQL  (Read 507 times)

0 Members and 1 Guest are viewing this topic.

Offline paragkalraTopic starter

  • Irregular
  • Posts: 29
  • Gender: Male
    • View Profile
    • paragkalra.com
[SOLVED] Storing "Non-English" characters under MySQL
« on: January 23, 2009, 10:36:22 AM »
I intend to display some Non-English (Hindi) language characters on a PHP page. Things work fine when I hardcode it on the PHP page and use following tag in the php page:
Quote
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Now I have stored the same characters into MySQL database and both the row & table collation are set to "utf8_unicode_ci"

However the characters are appearing garbled. Any idea what am I missing ?
Logged
Parag.A.Kalra, The Linux Man
http://www.paragkalra.com/
In this world without WALLS and GATES who need WINDOWS! USE LINUX! STOP PIRACY! GO OPEN SOURCE!

Offline effigy

  • Staff Alumni
  • Freak!
  • *
  • Posts: 7,301
  • Gender: Male
  • We must be the change we wish to see in the world.
    • View Profile
Re: Storing "Non-English" characters under MySQL
« Reply #1 on: January 23, 2009, 10:40:01 AM »
Logged
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

Offline paragkalraTopic starter

  • Irregular
  • Posts: 29
  • Gender: Male
    • View Profile
    • paragkalra.com
Re: Storing "Non-English" characters under MySQL
« Reply #2 on: January 24, 2009, 02:04:02 AM »
Thanks ... It worked ...
Logged
Parag.A.Kalra, The Linux Man
http://www.paragkalra.com/
In this world without WALLS and GATES who need WINDOWS! USE LINUX! STOP PIRACY! GO OPEN SOURCE!
Pages: [1]
« previous next »