Re: data type and Character set for DUTCH language
Dear Rick,
Thanks a lot for your reply as you always helped me with my issues.
I used collation utf8_unicode_ci as you suggested but it still gives error on inserting values into column c5 and c6 that "
Error Code: 1366. Incorrect string value: '\xE9 inta...' for column 'c5' at row 1". But when I use data type VARBINARY then error removed but value "Pré intake" is inserted as " PrÚ intake" which is not acceptable. Please help me to assist this issue.
Create table statement is mentioned below;
CREATE TABLE `test`.`InfoData` (
`c1` decimal(8,0) DEFAULT NULL,
`c2` decimal(8,0) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
`c4` varchar(20) DEFAULT NULL,
`c5` VARBINARY(255) DEFAULT NULL,
`c6` VARBINARY(255) DEFAULT NULL,
`c7` varchar(1) DEFAULT NULL,
`c8` decimal(10,0) DEFAULT NULL,
`c9` decimal(10,0) DEFAULT NULL,
`c10` decimal(10,0) DEFAULT NULL,
`c11` varchar(20) DEFAULT NULL,
`c12` varchar(1) DEFAULT NULL,
`c13` varchar(1) DEFAULT NULL,
`c14` varchar(1) DEFAULT NULL,
`c15` varchar(1) DEFAULT NULL,
`c16` decimal(1,0) DEFAULT NULL,
`c17` decimal(1,0) DEFAULT NULL
)ENGINE=InnoDB COLLATE utf8_unicode_ci;