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 '%kopiopaperi%' OR A.Alias LIKE '%kopiopaperi%' OR A.Code LIKE '%kopiopaperi%' OR A.Description LIKE '%kopiopaperi%' OR A.ShortDescription LIKE '%kopiopaperi%' OR A.Header LIKE '%kopiopaperi%' OR A.ManufactureCode LIKE '%kopiopaperi%' OR InvisibleTextForSearch LIKE '%kopiopaperi%')
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 '%kopiopaperi%') )
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 '%kopiopaperi%' OR A.Header LIKE '%kopiopaperi%' OR A.Alias LIKE '%kopiopaperi%' OR A.Code LIKE '%kopiopaperi%' OR A.Description LIKE '%kopiopaperi%' OR A.ShortDescription LIKE '%kopiopaperi%' OR A.ManufactureCode LIKE '%kopiopaperi%' OR A.Keywords LIKE '%kopiopaperi%' OR A.InvisibleTextForSearch LIKE '%kopiopaperi%') )
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 '%kopiopaperi%' OR A.Alias LIKE '%kopiopaperi%' OR A.Code LIKE '%kopiopaperi%' OR A.Description LIKE '%kopiopaperi%' OR A.ShortDescription LIKE '%kopiopaperi%' OR A.Header LIKE '%kopiopaperi%' OR A.ManufactureCode LIKE '%kopiopaperi%' OR A.Keywords LIKE '%kopiopaperi%' OR InvisibleTextForSearch LIKE '%kopiopaperi%' )
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