CODEWITHSUNDEEP
mysql
user2728627
user2728627

Reputation: 89

how to insert Indian language Telugu charactes in mysql

I want to store Indian language(Telugu) in my database table.But it is displaying ???? while inserting Telugu data into my table.I have verified some thing like below

SHOW VARIABLES LIKE ‘character_set_system’;

It displaying the output like Character_set_system| UTF8.

After that i have altered my talbe 

alter table lang modify characters varchar(12) character set utf8;

still do i need anything for that.

Upvotes: 1

Views: 3211

Answers (2)

Eswara Prasad
Eswara Prasad

Reputation: 21

Append characterEncoding=UTF-8 at the end of the database URL like this 

jdbc:mysql://localhost/test?characterEncoding=UTF-8

Before that set utf8_general_ci in your table column.

Upvotes: 2

Gautam Tak
Gautam Tak

Reputation: 129

use the Collation in DB for the particular field and set utf8_general_ci.

Upvotes: 1

Related Questions