| Database charset problems |
[eluser]Armorfist[/eluser]
I'm trying to make an insert with Active Record ($this->db->insert) and I'm getting the following error (MySQL database): Incorrect string value: '\xF3' for column 'address' at row 1 INSERT INTO `login_userdata` (`email`, `name`, `last_name`, `address`, `location`, `postal_code`, `phone`, `birth_date`, `sex`, `user_id`) VALUES ('[email protected]', 'Name', 'LastName', 'Cósta de Cáparica', 'Cósta de Cáparica', '2825-351', '2112121212', '28/02/89', '0', 12) The string that corresponds to the "address" column is "Cósta de Cáparica". I have the "<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />" tag in the html where form is, $config['charset'] = "UTF-8";, and the column where this data is inserted is collation "utf8_general_ci". Anyone has any idea whats going on? Thanks. |
| Messages In This Thread |
|
Database charset problems - by El Forum - 02-13-2008, 05:21 AM
Database charset problems - by El Forum - 02-13-2008, 07:41 AM
Database charset problems - by El Forum - 02-13-2008, 08:16 AM
Database charset problems - by El Forum - 02-13-2008, 09:55 AM
Database charset problems - by El Forum - 02-13-2008, 10:08 AM
Database charset problems - by El Forum - 02-13-2008, 10:34 AM
Database charset problems - by El Forum - 02-13-2008, 10:40 AM
Database charset problems - by El Forum - 02-13-2008, 10:53 AM
|
