Send persian string to mysql

user_10174150 0
Viewed 1214

I am trying to send Persian string to the mysql database;but it saves the data as something like this "%D8%AC%D8%AF%DB%8C%D8%AF" . English strings have no problem.

var new = $(this).val();
 $.ajax({
    url: '/url/' + new,
    type: 'GET',
    success: function () {
      window.location.href = window.location.href;
    }
  });

And here is my php code.

 public function url($new){
$db = Db::getInstance();
  $db->insert("INSERT INTO table (column) VALUES ('$new')");}

How can I resolve this problem?

There is something wrong with my url charachters. I found out that if I use the post method, it will be resolved. I am using MVC structure and I want to have some Persian strings in my url . so how can I resolve this new problem???...

mysql php jquery javascript database
4 Answers

Before insert Unicode character like persian or arabic in database you need to set Utf-8 characterset on db connection.

public function url($new){
$db = Db::getInstance();
$db->exec('SET NAMES utf8');
  $db->insert("INSERT INTO table (column) VALUES ('$new')");}

also for prevent any problem you must set database collation to utf8 general ci when creating databases that store persian characters or other unicode characters.

user_61518320

Modify your table

ALTER TABLE 'your table name' MODIFY 'column name' VARCHAR(20) CHARACTER SET UTF8;

For displaying Persian on your webpages you need to use code

<meta charset="UTF-8">

For URL :

$string = '%E0%A4%89-%E0%A4%85%E0%A4%B9%E0%A4%BF%E0%A4%B2%E0%A5%87-%E0%A4%95%E0%A4%B9%E0%A4%BE%E0%A4%81-%E0%A4%9B-%E0%A4%A4';

echo rawurldecode($string);

user_102879560

There are three layers that can be causing your problem. Firstly, your database will have a default character encoding. Secondly, your table can have an explicit character encoding which takes precedence. So you need to make sure you have a Unicode encoding set for your table through one of these methods. You say your table is set to utf8_general_ci so this part should be fine. Thirdly, there is the connection itself which has a specific encoding. This can be set up in MySQL client configuration defaults with the following: [mysqld] init_connect='SET NAMES utf8'

You can also set it in the code. For PHP for example, you might do the following: mysql_set_charset("UTF8", $conn); or $db->exec( 'SET CHARACTER SET UTF8' )

You haven't said anything about what $db is, so can't be certain. But something like that.

Finally, make sure it's not actually working but you just don't know it. Your web page should be set to utf8. Check what you're actually receiving from the web page and don't just assume it's sending Unicode.

user_100074880

Run this query to change the character set and collate of your table to support unicode characters.

ALTER TABLE <TABLE_NAME> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
user_53491990
Related