Some data not passing?

[mikebyrne]

I have a column names Fname which is set as Varchar but some data isn't going through. Im haveing problems with Tómas, Cnocán Glas and Mac Cóarailt.

 

What should I change the type to?

[revraz]

See if this helps

 

http://code.openark.org/blog/mysql/mysqls-character-sets-and-collations-demystified

[mikebyrne]

My SQL is

 

CREATE TABLE `test` (
  `Vote` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `ID` decimal(10,0) NOT NULL DEFAULT '0',
  `Sname` char(255) CHARACTER SET latin1 DEFAULT NULL,
  `Fname` char(255) CHARACTER SET latin1 DEFAULT NULL,
  `Address1` char(255) CHARACTER SET latin1 DEFAULT NULL,
  `Address2` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `Address3` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `Address4` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

I've found that the below supports my language but how do I apply it?

 

ISO 8859-1 Western European (Albanian, Basque, Breton, Catalan, Danish, Dutch, English, Faeroese, Finnish, French, German, Greenlandic, Icelandic, Irish Gaelic, Italian, Latin, Luxemburgish, Norwegian, Portuguese, Rhaeto-Romanic, Scottish Gaelic, Spanish, Swedish)

 

[fenway]

that is latin1...