• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
when sql query has utf character in it, codeigniter doesn't execute query

#3
[eluser]aman_tuladhar[/eluser]
Thanks Randy but the putting meta tag with character set UTF8 didn't solve the problem. However it seems that you also need to encode the model, controller, view file into UTF8 wihout BOM encoding to be able to execute query which has characters other than english.

Let me give example:
suppose u want to execute query like this,
$query = $this->db->get_where('tbl_product', array('title'=>"договору с Грузией"));

I used notepad++ to convert file (model, and controller) encoding from ansi to UTF8 without BOM, and magic happened the query executed.

Spend my whole day to this problem, hope it helps somebody else.


Messages In This Thread
when sql query has utf character in it, codeigniter doesn't execute query - by El Forum - 08-21-2008, 11:25 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.