2023-12-01 08:12:51 MySQL error: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Query:
SELECT KodMNN,idInstr FROM Tovar WHERE ((NamePure='������������ ����������')AND(KodMNN!=0))
File: /var/www/askorbin.ru/var.php Line: 1662023-12-01 08:12:51 MySQL error: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'locate'
Query:
SELECT count(DISTINCT Tovar.NamePure) FROM Tovar WHERE (Tovar.KodMNN != 0) AND (INSTR(NameTov,'������������')>0)AND(INSTR(NameTov,'����������')>0)