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
  • 974
  • 15
  • 39
  • 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
  • 1,988
  • 2
  • 17
  • 24