How to insert Persian link in database?

Question

I cant insert persian link in databse;

Example:

False:

http://jik545.ir/item-444352-%D9%BE%DB%8C%D8%A7%D9%85-%D8%B1%D8%B2%D9%85%D8%A7%DB%8C%D8%B4-%D8%AF%D8%B1%DB%8C%D8%A7%DB%8C%DB%8C-%D8%A7%DB%8C%D8%B1%D8%A7%D9%86-%D8%A8%D8%B1%D8%A7%DB%8C-%D9%85%D8%B0%D8%A7%DA%A9%D8%B1%D8%A7%D8%AA-%D9%87%D8%B3%D8%AA%D9%87-%D8%A7%DB%8C.html

True:

http://jik545.ir/item-444352-رزمایش-دریایی-ایران-برای-مذاکرات-هسته-ای.html

Could you please help me to achieve this?

**related :** http://stackoverflow.com/questions/6859018/save-data-in-arabic-in-mysql-database — adeneo, Feb 27 '15 at 16:43
or: http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — CD001, Feb 27 '15 at 16:44
... actually, that looks like it's url-encoded; and since it's an URL it's probably correct; just chuck it into http://meyerweb.com/eric/tools/dencoder/ and you'll see what I mean - you could probably run it through `urldecode()` (http://php.net/manual/en/function.urldecode.php) before entering it into the database. — CD001, Feb 27 '15 at 16:51

score 1 · Answer 1 · answered Feb 27 '15 at 16:41

1

Set the collation on the table/database/field to utf8

answered Feb 27 '15 at 16:41

Mateusz Majewski

280
1
10

You missed the database connector – CD001 Feb 27 '15 at 16:44
If you have done this, then the data should be stored as utf8. To retrieve it set also mysqli_set_charset() to utf8 – Mateusz Majewski Feb 27 '15 at 16:48
1

Possibly, but that could be down to it's settings. If you would store it in utf-8, retrieve it in UTF8 and display it in UTF8 it would work. – Mateusz Majewski Feb 27 '15 at 17:06

How to insert Persian link in database?

1 Answers1