将Gujarati文本插入MySQL表会导致垃圾字符和不可读的文本 [英] Inserting Gujarati text into a MySQL tables results in junk characters and unreadable text

问题描述

我有三个MySQL表，我插入古吉拉特内容到他们。当我插入两个表，它们插入精细，可读，但在一个表中，它显示垃圾字符/不可读的文本。如何解决此问题？

I have three MySQL tables and I'm inserting Gujarati content into them. When I insert two tables, they're inserted fine and are readable but in one table, it is showing junk characters/unreadable text. How can I fix this?

推荐答案

MySQL有每表字符集设置。

您正在使用每个表格 - 请参阅如何查看MySQL中的数据库/表/列是什么字符集？。

You can check which character set you are using for each table - see How do I see what character set a database / table / column is in MySQL?.

如果这是你的问题，能够隐藏所讨论的表，使用：

If that is your problem, you might be able to covert the table in question, using:

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

这篇关于将Gujarati文本插入MySQL表会导致垃圾字符和不可读的文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！