COLLATION对于与我的设置不符的CHARACTER SET无效

I found a workaround for this one particular case. However, I still didn't find why the queries made through Adminer and Mysqli returned different results and especially why the error message points to charsets not included in any variable?推荐答案 kat.kategorie的数据类型是什么?What is the datatype of kat.kategorie ?GROUP_CONCAT( kat.kategorie ORDER BY CONVERT(kat.kategorie USING utf8) COLLATE utf8_czech_ci )您可能还需要致电CAST(... AS CHAR).将来，请勿混合使用CHARACTER SET.In the future, do not mix CHARACTER SETs. GROUP_CONCAT以及涉及组合事物的其他几个函数在推断结果类型应该是什么方面存在问题.在某些情况下，它会下标并调用结果BINARY，它甚至比您遇到的还要糟糕.GROUP_CONCAT, and a couple of other functions that involve combining things, have a problem in deducing what the result type should be. In some cases, it punts and calls the result BINARY, which is even worse than what you encountered.我认为某个地方存在latin1会导致您遇到特定的问题.进入管理员.让我们看看SHOW CREATE TABLE KAT.I believe that there is a latin1 somewhere that led to your particular problem. Dig into Adminer. Let's see SHOW CREATE TABLE kat. 这篇关于COLLATION对于与我的设置不符的CHARACTER SET无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 1403页，肝出来的..