im trying to search a table in a database for a hebrew string, the where clause is: "WHERE field LIKE '%$var'".
when i run the query i get:
1267: Illegal mix of collations (hebrew_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'.
i have tried changing everything (and i do mean, everything) in the database, tables and fields collation properties to hebrew, but didnt do anything, i think that it has something to do with the servers character sets properties, but i didnt succeed in changing it, starting mysqld with --default-character-set=hebrw didnt help, and i have no idea what query to type in the mysql shell command-line interface.
the question is: how do i change it?
i tried doing a full text search, but it didnt come up with any results, is there any way to search a database? (search with the postion of the string, it is very important)