No rows returned when using codeigniter sqlsrv with arabic words in where clause

Asked Oct 20 '19 at 12:20

Active Oct 20 '19 at 14:29

Viewed 62 times

I have codeigniter connected to sqlsrv DB i want to use Arabic words in a where clause:

$this->db—>get_where(“codes”,array(“name”,”كلمة”);

note: sqlsrv driver installed correctly

The problem is that while using Arabic words in to select rows I get 0 rows returned. I tested in laravel framework where it works but in codeigniter I get 0 rows

edited Oct 20 '19 at 14:29

robsiemb

6,157
7
32
46

asked Oct 20 '19 at 12:20

radwan tarhini

2

What is the problem that you experience? – Lajos Arpad Oct 20 '19 at 12:48
while using arabic words in to select rows i get 0 rows. i tested in laravel framework it works but in codeigniter i get 0 rows :/ – radwan tarhini Oct 20 '19 at 13:02
Check out that question: https://stackoverflow.com/questions/9178795/how-to-store-multi-byte-characters-in-sql-server-database-using-codeigniter which I think will help you to fix your issue. – TheMisir Oct 20 '19 at 13:03
i tried it not works i think the problem in codeigniter sqlsrv driver – radwan tarhini Oct 20 '19 at 13:05
Do you have errors? – Lajos Arpad Oct 20 '19 at 13:07
no there is no errors in php and mssql “debug logs turned on” – radwan tarhini Oct 20 '19 at 13:15

No rows returned when using codeigniter sqlsrv with arabic words in where clause

0 Answers0