How to insert urdu data in mysql using php script?

Question

I have alot of data in urdu and I want to store in in database using php script. Someone please help me. I have tried all these things , mysqli_set_charset($link,"utf8"); and also change the collation to utf8_general_ci but its not working.

@AshnaAli your question could be duplicate so provide some code example this can help resolving your issue — Abdul Rafay, Mar 03 '17 at 07:42

score 1 · Answer 1 · edited May 23 '17 at 12:32

It's not clear to me from your question where your problem lies: is it that your MYSQL tables are not in UTF8, or is it that your Urdu data is not in UTF8?

To create a MYSQL table in UTF8, use a CREATE statement such as:

  CREATE TABLE tableName (
      col1 INT,
      (etc.)
  ) DEFAULT CHARSET utf8;

To alter an existing table, use an UPDATE command such as

  ALTER TABLE tab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

see also this answer: How to change all the tables in my database to UTF8 character set?

Or, for more ways of changing the MYSQL encoding using PHP functions, see this answer: Error in insertion urdu data in php Mysql

To convert PHP strings to UTF8 if you don't know your encoding, see this answer: PHP: Convert any string to UTF-8 without knowing the original character set, or at least try

How to insert urdu data in mysql using php script?

1 Answers1