Erro manipulação executar! select ac02nome, ac03nome, an02codigo, an03codigo, (select count(*) from tb02prod_grupo
where an02grupo=an03codigo and an02nivel=2 and ac02produto in (
select ac10codigo from tb10produto where ac10sit="S" and ac10nome like "%电脑如何截长图%")) tot
from tb03secao left join tb02departamento on (an02codigo=an03departamento)
where ac03sit="S" and ac02sit="S" having tot > 0 order by ac02nome, an02codigo, ac03nome 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'Erro manipulação executar! select distinct an06codigo, ac06nome from tb06marca
left join tb10produto on (an10marca=an06codigo) where ac06sit="S" and ac10nome like "%电脑如何截长图%" order by ac06nome 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Erro manipulação executar! select count(*) tot from tb10produto where ac10sit <> "N" and an10preco > 0.00 and (ac10nome like "%电脑如何截长图%" or ac10palavra like "%电脑如何截长图%" or ac10codigo="电脑如何截长图"
or ac10barra="电脑如何截长图") 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Erro manipulação executar! select ac10codigo, ac10nome, ac10ref, an10preco, an10prom, ad10prom_fim, ad10prom_ini,
ac10prom, ac10estoque, ac10sit, ac10opcao, ac10orcamento, ac10url, ac10pronta, an10pix, ac10montagem, ac06nome,
(select if(sum(an12saldo) > 0,1,(select if (sum(an10saldo)>0,1,0) from tb10prod_filial where ac10produto=ac10codigo))
from tb12prod_opcao where ac12produto=ac10codigo) sald,
coalesce((select count(*) from tb21vendaitem where ac21prod=tb.ac10codigo),0) vendido from tb10produto tb left join tb06marca on (an06codigo=an10marca)
where ac10sit <> "N" and an10preco > 0.00 and (ac10nome like "%电脑如何截长图%" or ac10palavra like "%电脑如何截长图%" or ac10codigo="电脑如何截长图"
or ac10barra="电脑如何截长图") order by ac10sit, sald desc, rand(421010008) limit 0 , 24 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
