database problem-mysql_fetch_object()

[firelior]

Hi,
I have this:
[code]SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'[/code]
which is in hebrew.
now. when I enter this through the phpmyadmin I don't get any error but when I do this:
[code]
$sql="SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'";
$result = mysql_query($sql);
while ($row = mysql_fetch_object($result))
{
      echo $row->id;
}
[/code]
I get this error:
[code]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource[/code]
Please help.
THANKS

[HuggieBear]

OK, I'd have thought that the query failed... Try this:

[code]
$sql="SELECT * FROM cars WHERE `area` LIKE '%ירושלים%'";
$result = mysql_query($sql) or die ("Couldn't execute $sql: " .mysql_error());
[/code]

Regards
Huggie

[craygo]

might want to try and escape out the value before the query

[code]$value = mysql_real_escape_string("ירושלים");
$sql="SELECT * FROM cars WHERE `area` LIKE '%$value%'";[/code]

Ray

[firelior]

ok,
[b]huggy[/b]: what it does is this: [code]Couldn't execute SELECT * FROM cars WHERE `area` LIKE '%ירושלים%': Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'[/code]

and ray..it doesn't work. its still the same

[firelior]

found the problem..
i just changed the field type to varBINARY