problem that never solved in this forum plz help me i read all topics on this

[lior.amrosi]

hello i add a product in admin panel and i get this massage
i cheack the encoding in the table on db and it fine i have 3 site with prestashop and only 1 of them give me this problem
i try to Re-build entire index in search tab and i get a 404 error

plz help me thanks!!
Array
(
[0] => Incorrect string value: '\xD7' for column 'word' at row 1
[1] => Array
(
[0] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'ו�' AND id_lang = 4 LIMIT 1),4)
[1] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'עימה' AND id_lang = 4 LIMIT 1),4)
[2] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'שלט' AND id_lang = 4 LIMIT 1),4)
[3] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'רחוק' AND id_lang = 4 LIMIT 1),4)
[4] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'אורך' AND id_lang = 4 LIMIT 1),1)
[5] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'עשוי' AND id_lang = 4 LIMIT 1),1)
[6] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'מסיליקון' AND id_lang = 4 LIMIT 1),1)
[7] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'דרשות' AND id_lang = 4 LIMIT 1),1)
[8] => (42,(SELECT id_word FROM ps_search_word WHERE word = 'סוללות' AND id_lang = 4 LIMIT 1),1)
[9] => (42,(SELECT id_word FROM ps_search_word WHERE word = '3xaa' AND id_lang = 4 LIMIT 1),1)
)

)

[Radu]

check the columns for utf-8 also not only the table.

[Radu]

this is what I found so far:
http://stackoverflow.com/questions/4571044/problem-with-hebrew-mysql-c

[Ehinarr]

The value problem is written this way? ‘\xD7’

[lior.amrosi]

this is what I found so far:
http://stackoverflow.com/questions/4571044/problem-with-hebrew-mysql-c

sorry it's doesnt work, but tnx

The value problem is written this way? ‘\xD7’

yes