• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database charset problems

#1
[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@test.com', '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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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