问题描述
我有2个表，我想加入这些表.但是一个表排序规则是 utf8_turkish_ci ，另一个是 utf8_general_ci .这些表很大(2.9GB/550MB)，所以我不想在查询中使用" COLLATION "关键字，因为它已减速到我的查询中.
I have 2 table and I want to do join those tables. But one table collation is utf8_turkish_ci another is utf8_general_ci. These tables are big (2.9GB / 550MB) So I don't want to use "COLLATION" keyword in query because it's decelerated to my query.
我的问题是:我是否将表COLLATION从utf8_turkish_ci更改为utf8_general_ci如此乱码或更改行中的任何字符?
My question is: if I change the table COLLATION from utf8_turkish_ci To utf8_general_ci so garble or change any character in rows?
谢谢
推荐答案
更改排序规则不会更改字符.排序规则是一个规则(或多个规则)，用于说明如何比较字符.
Collation changing do not change characters. The collation is a rule (or rules) which say how to compare characters.
从文档- A字符集是一组符号和编码.排序规则是一组用于比较字符集中的字符的规则.
这篇关于MySQL表集合utf8_turkish_ci到utf8_general_ci的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！