James Sherwood wrote:
> We are trying to upgrade from 4.0 to 5 and we are not having any luck on
> the character sets.
> We need to use French characters for some things.
> We have tried setting utf8 for everything we can find but the characters
> still show all screwed up..
> I have read the manual regarding all the variables and have placed all I
> can in the my.ini etc.
> Can someone who has it working post the relevant info from their ini
> file along with any help for other setting we need to change?
Are you referring to data that is inserted via the client? If so, make
sure to issue the following upon connecting:
SET NAMES utf8;
SET CHARACTER SET utf8;
Was this dumped from the version 4.x DB? Are you sure that it really is
If this is a web app, do you see any difference betwen the browser and a
terminal? If you're looking at it through a browser, ensure that the
correct character set header is sent out.