Me pehea te tiaki i a Emoji ki MySQL? Whakauruhia ki te paataka korero Emoji tohu patai raru raru

Mena kei te rongoa te whakaaturanga Emoji ki te whakawaehere utf8pātengi raraunga MySQLMariaDB ranei, kaore e taea te whakaatu.

He aha te kupu Emoji i uru ki roto i te putunga raraunga ka waiho hei tohu patai?

Na te mea he 4-paita nga korero a Emoji, a ko te huinga utf8 e tautoko ana i te 1-3 paita noa o nga tohu, kaore e taea te tuhi i nga korero Emoji ki roto i te paataka raraunga.

Me pehea te whakatau i te raru i uru mai ai te kupu Emoji ki roto i te papaa raraunga ka waiho hei tohu patai?

E rua nga otinga:

1. Whakauruhia te kuputuhi ma te ringa, me te whakakapi i nga tohu wha-paita ki nga tohu ritenga.
2. whakarerekē MySQL Te huinga pūāhua pātengi raraunga, huri i te huinga pūāhua pātengi raraunga mai i utf8 ki utf8mb4, tautokohia ngā pūāhua paita 1-4.

Ko te tikanga, ko te tikanga tuatahi he nui rawa te mahi me te kore e pai.

E taunaki ana ki te whakamahi i te otinga tuarua, whakarereke i te huinga pūāhua pātengi raraunga MySQL.

Ka timata mai i te putanga MySQL 5.5.3, ka taea e te papaunga raraunga te tautoko i te huinga ahua utf4mb8 o te 4 paita, ka eke ki te 4 paita te ahua, no reira ka taea e ia te tautoko atu i nga huinga ahua, ka taea hoki te penapena i nga whakaaturanga Emoji.

• Whai muri i a MySQL 5.5.3, ka taea e koe te whakapai ake ki te huinga pūāhua utf8mb4.
• I taua wa ano, he hototahi a utf8mb4 ki te huinga pūāhua utf8.
• Kei utf8mb8 te whakawaehere, te waahi me te rokiroki o nga tohu utf4.
• He rite ki te huinga pūāhua utf8, karekau he kino ki nga raraunga o naianei.

Nā kiphpMyAdminMo nga ripanga katahi ano ka waihangahia i roto i te putunga raraunga hou, ko te whakawaehere pūāhua taunoa ko:Latin1

• Kaore e taea e tenei whakawaehere te whakauru i nga korero Hainamana me Emoji;
• Me huri e koe te whakawaehere huinga pūāhua o te huinga pūāhua pātengi raraunga me te ripanga ki utf8mb4;
• Na, whakaara ano i a MySQL, ka taea e koe te whakauru i nga korero Hainamana me Emoji.

otinga raruraru pūāhua MySQL Emoji

taahiraa 1:Whakakētia te kōnae whirihoranga MySQL my.cnf

• (Ko te tūmau Windows taku.ini,LinuxKo taku.cnf te tūmau)
• my.cnf kōnae, te tikanga kei roto/etc/mysql/my.cnftūranga
• Paewhiri Mana CWPKei roto te kōnae my.cnf/etc/my.cnftūranga

Ka kitea e koe, taapirihia nga korero e whai ake nei ki nga wahanga e toru e whai ake nei ▼

[client]

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

taahiraa 2:Tīmataria anō te pātengi raraunga MySQL

service mysqld restart

Hipanga 3: Tirohia te huinga pūāhua ka tomo ▼ i roto i te rārangi whakahau SQL

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_database';

Tirohia mehemea e whai ake nei ▼

Whakauruhia te whakahau SQL e whai ake nei▼

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';

Tirohia mehemea e whai ake nei▼

 +--------------------------+--------------------+

| Variable_name | Value |

+--------------------------+--------------------+

| character_set_client | utf8mb4 |

| character_set_connection | utf8mb4 |

| character_set_database | utf8mb4 |

| character_set_filesystem | binary |

| character_set_results | utf8mb4 |

| character_set_server | utf8mb4 |

| character_set_system | utf8 |

| collation_connection | utf8mb4_unicode_ci |

| collation_database | utf8mb4_unicode_ci |

| collation_server | utf8mb4_unicode_ci |

+--------------------------+--------------------+

I muri i te hanga i tetahi papaa raraunga hou ki phpMyAdmin, meTirohia te waehere pātengi raraunga ▼

SHOW CREATE DATABASE db_name;

• Pēnei i:SHOW CREATE DATABASE test;

Mena karekau te whakawaehere raraungautf8mb4, me whakarerekē e koe te huinga pūāhua pātengi raraunga kiutf8mb4 .

Me pehea te whakarerekē i te huinga pūāhua pātengi raraunga ki te utf8mb4?

Hipanga 1: Pāwhiritia te ingoa pātengi raraunga o nāianei i roto i phpMyAdmin, ka pāwhiri SQL.

Hipanga 2: Whakauruhia te whakahau e whai ake nei hei whakarerekē i te huinga pūāhua pātengi raraunga kiutf8mb4▼

ALTER DATABASE db_name DEFAULT CHARACTER SET utf8mb4

• Pēnei i:ALTER DATABASE test DEFAULT CHARACTER SET utf8mb4;

taahiraa 3:Tīmataria anō te pātengi raraunga MySQL

service mysqld restart

• Koia tena.

Anei etahi tauira o nga whakahau SQL:

Hurihia te huinga pūāhua taunoa me ngā tīwae pūāhua katoa o te ripanga ki te huinga pūāhua hōu ▼

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8_general_ci;

• Pēnei i:ALTER TABLE logtest CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8_general_ci;

Mēnā ka whakarerekē noa koe i te huinga pūāhua taunoa o te ripanga▼

ALTER TABLE tbl_name  DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci;

• Pēnei i:ALTER TABLE logtest DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci;

Whakakēhia te huinga pūāhua o tētahi āpure ▼

ALTER TABLE tbl_name CHANGE c_name c_name CHARACTER SET character_name 

• Pēnei i:ALTER TABLE logtest CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;

Tirohia te waehere ripanga ▼

SHOW CREATE TABLE tbl_name;

Tirohia nga Waehere Mara ▼

SHOW FULL COLUMNS FROM tbl_name;

Tirohia te waehere pātengi raraunga o nāianei ▼

SHOW VARIABLES LIKE 'character_set_%';

• Ko te putea taraiwa mysql-connector-java e tautoko ana i te utf5.1.13mb8 i roto i te 4+