Special characters in Mysql

... do not display correct

[turbohost]

hi Guys,

I'm trying to import some special French characters into a Mysql table but I get some incorrect characters in the database. For example 'cuvée' becomes 'cuvée'. Is there a way I can change this?

Thx,
turbo

[encyclo]

The difference you are seeing is that your initial text is probably encoded as UTF-8 and the database as ISO-8859-1. You need to convert the DB to UTF-8 - the only way I know how is to dump the DB to a file and use

iconv

, but there may well be an easier way - I'd wait until some of the database experts chime in. ;)