Whether you need when ordering and COLLATE mysql5.7.32 Chinese gbk_chinese

Home > database > Whether you need when ordering and COLLATE mysql5.7.32 Chinese gbk_chinese_ci

Whether you need when ordering and COLLATE mysql5.7.32 Chinese gbk_chinese_ci

Time：04-09

1, the select * from tableName CONVERT (FieldName USING GBK)
2, the select * from tableName CONVERT (FieldName USING GBK) COLLATE gbk_chinese_ci
These two kinds of writing, can get sorting, what's the difference? Whether you need to add "followed COLLATE gbk_chinese_ci"?
For mysql5.7.32 version use which write better?

Page link：https//www.codepudding.com/database/107398.html

Prev:Oracle custom data type value in the process of debugging code to check the problem.

Next:Is there any possible MD5 checksum value and SHA256 check all match but different two files

Tags：

MySQL

Links：
CodePudding