SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT A.KeyID FROM Product A
WHERE (A.Name LIKE '%v��rillinen%' OR A.Alias LIKE '%v��rillinen%' OR A.Code LIKE '%v��rillinen%' OR A.Description LIKE '%v��rillinen%' OR A.ShortDescription LIKE '%v��rillinen%' OR A.Header LIKE '%v��rillinen%' OR A.ManufactureCode LIKE '%v��rillinen%' OR InvisibleTextForSearch LIKE '%v��rillinen%') AND (A.Name LIKE '%tulostuspaperi%' OR A.Alias LIKE '%tulostuspaperi%' OR A.Code LIKE '%tulostuspaperi%' OR A.Description LIKE '%tulostuspaperi%' OR A.ShortDescription LIKE '%tulostuspaperi%' OR A.Header LIKE '%tulostuspaperi%' OR A.ManufactureCode LIKE '%tulostuspaperi%' OR InvisibleTextForSearch LIKE '%tulostuspaperi%')
AND A.LanguageID = 1
AND A.Visible = 1
AND A.Code NOT LIKE '%K'
AND A.Code NOT LIKE '%T' /data/www/eco-toimistotarvikkeet.fi/index.php at line 549
SQL Error
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT A.Alias, A.Name, A.Price, A.KeyID
FROM Product A
WHERE ( (A.Name LIKE 'v��rillinen%') AND (A.Name LIKE '%tulostuspaperi%') )
AND A.Visible = 1
AND A.Code NOT LIKE '%K'
AND A.Code NOT LIKE '%T'
ORDER BY A.Header ASC LIMIT 120 /data/www/eco-toimistotarvikkeet.fi/index.php at line 577
SQL Error
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT A.Alias, A.Name, A.Price, A.KeyID
FROM Product A
WHERE ( (A.Name LIKE '%v��rillinen%' OR A.Header LIKE '%v��rillinen%' OR A.Alias LIKE '%v��rillinen%' OR A.Code LIKE '%v��rillinen%' OR A.Description LIKE '%v��rillinen%' OR A.ShortDescription LIKE '%v��rillinen%' OR A.ManufactureCode LIKE '%v��rillinen%' OR A.Keywords LIKE '%v��rillinen%' OR A.InvisibleTextForSearch LIKE '%v��rillinen%') AND (A.Name LIKE '%tulostuspaperi%' OR A.Header LIKE '%tulostuspaperi%' OR A.Alias LIKE '%tulostuspaperi%' OR A.Code LIKE '%tulostuspaperi%' OR A.Description LIKE '%tulostuspaperi%' OR A.ShortDescription LIKE '%tulostuspaperi%' OR A.ManufactureCode LIKE '%tulostuspaperi%' OR A.Keywords LIKE '%tulostuspaperi%' OR A.InvisibleTextForSearch LIKE '%tulostuspaperi%') )
AND A.Visible = 1
AND A.Code NOT LIKE '%K'
AND A.Code NOT LIKE '%T'
ORDER BY A.Header ASC LIMIT 120 /data/www/eco-toimistotarvikkeet.fi/index.php at line 580
SQL Error
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT count(A.KeyID) as count
FROM Product A
WHERE (A.Name LIKE '%v��rillinen%' OR A.Alias LIKE '%v��rillinen%' OR A.Code LIKE '%v��rillinen%' OR A.Description LIKE '%v��rillinen%' OR A.ShortDescription LIKE '%v��rillinen%' OR A.Header LIKE '%v��rillinen%' OR A.ManufactureCode LIKE '%v��rillinen%' OR A.Keywords LIKE '%v��rillinen%' OR InvisibleTextForSearch LIKE '%v��rillinen%' ) AND (A.Name LIKE '%tulostuspaperi%' OR A.Alias LIKE '%tulostuspaperi%' OR A.Code LIKE '%tulostuspaperi%' OR A.Description LIKE '%tulostuspaperi%' OR A.ShortDescription LIKE '%tulostuspaperi%' OR A.Header LIKE '%tulostuspaperi%' OR A.ManufactureCode LIKE '%tulostuspaperi%' OR A.Keywords LIKE '%tulostuspaperi%' OR InvisibleTextForSearch LIKE '%tulostuspaperi%' )
AND A.LanguageID = 1
AND A.Visible = 1
AND A.Code NOT LIKE '%K'
AND A.Code NOT LIKE '%T' /data/www/eco-toimistotarvikkeet.fi/index.php at line 748