Sunday 3 June 2018

php - How To Store Tamil Font in mysql database




$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";
$conn = mysqli_connect($servername, $username, $password, $dbname);
$sql = "Insert into tbl (name) VALUES ('ஆன்லைனில்')";
$result = mysqli_query($conn, $sql);



But Its Store Db in
ஆனà¯à®²à¯ˆà®©à®¿à®²à¯


Answer



Change the column format



ALTER `tbl` CHANGE `column_name` `column_name` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;

No comments:

Post a Comment

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...