• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help with MySQL character sets and collations

#1
[eluser]Daniel Peraza[/eluser]
Hi!, I'm using the Active Record Class to store user-edited data into a MySQL 5 DB, which uses utf8_general_ci as collation. The problem is that A.R.C. is not sanitizing the data properly and when I try to use spanish characters such as áéíóúñ, the data is stored in the DB as áéí&At;.

My database.php config file has these settings:

Code:
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";


Messages In This Thread
Help with MySQL character sets and collations - by El Forum - 11-14-2008, 02:59 PM
Help with MySQL character sets and collations - by El Forum - 02-10-2009, 11:58 AM
Help with MySQL character sets and collations - by El Forum - 02-10-2009, 12:18 PM
Help with MySQL character sets and collations - by El Forum - 02-10-2009, 01:02 PM
Help with MySQL character sets and collations - by El Forum - 02-10-2009, 01:11 PM
Help with MySQL character sets and collations - by El Forum - 02-11-2009, 12:05 PM
Help with MySQL character sets and collations - by El Forum - 02-11-2009, 04:16 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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