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



Theme © iAndrew 2016 - Forum software by © MyBB