problem with Arabic search

[mzh mzh]

hi every body
i have mysql 5.38 on hosting company
with character set cp1256
and i have a table called customer
this table is character set cp1256 and cllation cp1256_general_ci
i transfer the the arabic data into this table and every thing is ok!

the probelm is :
when i execute a sql query
(select cus_name from customers where cus_name = 'اسم')
no result return
even if i write (set character set cp1256;) before the query

the (like = '%اسم%') statment is not working too
even with blob column field

so any body have an idea about this??



Edited 1 time(s). Last edit at 02/20/2007 07:47AM by mzh mzh.