Sandesh
Sandesh

Reputation: 29

php mysql and unicode

I am trying to insert unicode content on phpmyadmin in xampp. I set both the collation for my database and for my table to utf8. But whenever I am trying to insert the unicode data(i.e. Nepali or hindi fonts), the data is stored like this: The highlighted text.

The data is displayed correctly. As I have set charset on meta tag to utf-8. The main problem is I want to store the data as it is.

Is there any way to store the data as it is? The data actually is: "समाचार".

Upvotes: 1

Views: 1734

Answers (1)

Ultimater
Ultimater

Reputation: 4738

You need to set the charset on the adapter so it doesn't corrupt the characters before trying to insert them. Since you're using MySQLi as your database adapter, you'd be looking for one of the following solutions:

// Procedural style
mysqli_set_charset($link, "utf8");

// Object oriented style
$mysqli->set_charset("utf8");

See the manual entry for set_charset here: http://php.net/manual/en/mysqli.set-charset.php


You can also run an initial query SET NAMES utf8.

Upvotes: 1

Related Questions