如何在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’;
它显示类似于Character_set_system| UTF8
的输出.
在那之后,我改变了我的脸谱
After that i have altered my talbe
alter table lang modify characters varchar(12) character set utf8;
我还需要什么吗?
答
在数据库URL的末尾附加characterEncoding=UTF-8
Append characterEncoding=UTF-8
at the end of the database URL like this
jdbc:mysql://localhost/test?characterEncoding=UTF-8
在此之前,在表格列中设置utf8_general_ci
.
Before that set utf8_general_ci
in your table column.