Re: insert in dB string whit 8bit caracter

[Fernando Gonzalez Sanchez]

Which character set has the table you are using?

For example, the following sql will create a UTF-16 table
CREATE TABLE `actor` (
`actor_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf16

The character set in MySql tables must match the encoding used in .NET.