如何使用非英语(孟加拉)语言将数据输入此数据库表? [英] How can I enter data using non English (Bangla) language into this database table?

问题描述

如何使用非英语(孟加拉)语言将数据输入此数据库表?

How can I enter data using non English (Bangla) language into this database table ?

推荐答案

@Tim指出，您需要将表/数据库/列的collation更改为UTF-8.首先检查database/table/column的排序规则.

As pointed out by @Tim you need to change the collation of your table/database/column to UTF-8. First check the collation of your database/table/column.

检查分类:

如何检查数据库的排序规则:

SELECT
    default_character_set_name
FROM
    information_schema.SCHEMATA
WHERE
    schema_name = "YOUR_DATABASE_NAME";

如何检查TABLE的排序规则:

SELECT
    CCSA.character_set_name
FROM
    information_schema.`TABLES` T,
    information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE
    CCSA.collation_name = T.table_collation
AND T.table_schema = "YOUR_DATABASE_NAME"
AND T.table_name = "YOUR_TABLE_NAME";

如何检查列的排序规则:

SELECT
    character_set_name
FROM
    information_schema.`COLUMNS`
WHERE
    table_schema = "YOUR_DATABASE_NAME"
AND table_name = "YOUR_TABLE_NAME"
AND column_name = "YOUR_COLUMN_NAME";

---

更改收藏夹:

如何更改数据库排序规则:

ALTER DATABASE YOUR_DATABASE_NAME CHARACTER SET utf8 COLLATE utf8_unicode_ci;

如何更改表格排序规则:

ALTER TABLE YOUR_TABLE_NAME CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

如何更改列排序规则:

ALTER TABLE YOUR_TABLE_NAME MODIFY YOUR_COLUMN_NAME VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

示例:

DROP TABLE IF EXISTS `sample_table`;
CREATE TABLE `sample_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO sample_table(name,language) VALUES('Ed Sheeran','English');
INSERT INTO sample_table(name,language) VALUES('আয়েশা খাতুন সুজানা','আমার সোনার বাংলা');

看，表定义中使用的CHARSET是utf8.因此，您可以将unicode characters存储在表中.

Look, the CHARSET used in the table definition is utf8. So, you can store unicode characters in the table.

检查数据是否正确插入.

Check whether the data inserted correctly or not.

SELECT * FROM sample_table;

结果:

| id |               name |         language |
|----|--------------------|------------------|
|  1 |         Ed Sheeran |          English |
|  2 |    আয়েশা খাতুন সুজানা |  আমার সোনার বাংলা |

这篇关于如何使用非英语(孟加拉)语言将数据输入此数据库表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！