How To Store Tamil Font in mysql database

Question

<?php 
$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
à®†à®©à¯à®²à¯ˆà®©à®¿à®²à¯

Obligatory JoelOnSoftware: https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/ — Loek, Jun 01 '18 at 09:01
My table Structure SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; SET NAMES utf8mb4; DROP TABLE IF EXISTS `tbl`; CREATE TABLE `tbl` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; — Ragupathi, Jun 01 '18 at 09:05

score 4 · Accepted Answer · answered Jun 01 '18 at 09:04

4

Change the column format

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

answered Jun 01 '18 at 09:04

Sree KS

1,311
1
13
26

Sir Again Save à®†à®©à¯à®²à¯ˆà®©à®¿à®²à¯ this format – Ragupathi Jun 01 '18 at 09:37
Previous data you won't get back – Sree KS Aug 01 '18 at 12:32
add TABLE in between ALTER and table name Ex: ALTER TABLE `tbl` – Rajil TL Jun 17 '22 at 15:36

score 0 · Answer 2 · answered Jun 01 '18 at 11:52

0

ALTER TABLE sample.sample_table CHARACTER SET = utf8 ;

answered Jun 01 '18 at 11:52

Sachin Kumar

9
3

score -1 · Answer 3 · edited Aug 06 '19 at 06:46

-1

ALTER TABLE `mst_lyrics` CHANGE `lyrics_title` `lyrics_title` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

edited Aug 06 '19 at 06:46

cs95

379,657
97
704
746

answered Aug 06 '19 at 06:22

Harish Karam

1

2

Harish Karam Have a look here on how to readably format your posts. https://stackoverflow.com/editing-help Also, please augment your code-only answer with some explanation, in order to help fighting the misconception that StackOverflow is a free code writing service. – Yunnosch Aug 06 '19 at 06:25

How To Store Tamil Font in mysql database

3 Answers3