当对非ascii字符建立索引时,最大字符长度将减少。
The maximum character length will be reduced when non-ASCII characters are indexed.
如果使用可空的varchar列并只涉及ASCII字符(在utf - 8格式中每字符1字节),那么可以建立索引的最大字符长度是1021个字符。
If you use a nullable VARCHAR column and only ASCII characters (UTF-8 format 1 byte per character) involved, the maximum character length that can be indexed is 1021 characters.
您可以使用——show - limits选项显示xargs的默认限制,然后使用- s选项将输出命令的长度限制在允许的最大字符串数量之内。
You can use the — show-limits option to display the default limits of xargs, and the -s option to limit the size of output commands to a specific maximum number of characters.
应用推荐