Welcome Guest, Not a member yet? Register   Sign In
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



Theme © iAndrew 2016 - Forum software by © MyBB