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

#3
[eluser]Armorfist[/eluser]
The datatype of all fields except "user_id", "sex" and "birthdate" is varchar(255). I cannot add that string (Cósta de Cáparica) to any of them.

SQL of the table:
Code:
CREATE TABLE `login_userdata` (
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `birth_date` date NOT NULL,
  `sex` int(11) NOT NULL,
  `notes` varchar(80) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I can insert normally if i do not use "special" chars like "ó".

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.