Can't search for arabic characters in Sybase ASE 16 univarchar field type

Asked Feb 09 '16 at 12:41

Active Mar 17 '18 at 12:58

Viewed 353 times

I have a table with two fields id and name. Name field store arabic names like مينا and محمد when i write:

select * from tablename where name like '%مينا%'

there is no output but i can see the table with arabic characters when write:

select * from tablename

could anyone help me to solve this problem?

edited Mar 17 '18 at 12:58

Cœur

asked Feb 09 '16 at 12:41

Mina_girgis

try: `select * from tablename where name like '%مينا%' collate 1256ARA` – Haytem BrB Feb 09 '16 at 14:08
got error: Incorrect syntax near 'collate' – Mina_girgis Feb 10 '16 at 07:37
'collate' is not a supported construct in Sybase ASE. Perhaps the issue is the client-server character set conversion? Did you try the -J utf8 option? (if you're using 'isql') – RobV Feb 11 '16 at 11:35
Thank you RobV yes its about client charset. – Mina_girgis Feb 11 '16 at 13:15
RobV your comment is an answer to me. – Mina_girgis Feb 11 '16 at 13:15

0 Answers0