1

I am having problems storing urdu characters in Mysql table. Values from HTML form are stored in tables but when I view in phpmyadmin, it shows weird characters.

I have tried ucs2 and utf8 collations but still new values which I store are unknown characters.

What is the correct collation type? Or is there anything else that is wrong?

Thanks

Waleed
  • 1,097
  • 18
  • 45
  • 1
    Check your connection or just set it to be utf-8 http://php.net/manual/en/mysqli.set-charset.php – exussum Sep 11 '16 at 17:34
  • Don't use ucs2. If you have further troubles, start a new question, supply `SHOW CREATE TABLE` and your connection parameters. – Rick James Sep 11 '16 at 22:08

1 Answers1

3

Try setting your column as utf8-utf8_general_ci like this if you are using MySQL workbench.

enter image description here

Then you will be able to save urdu characters

enter image description here

Recommend using utf8_unicode_ci for accuracy

Kiran Muralee
  • 2,068
  • 2
  • 18
  • 25