Re: utf8 character show as ???

[Shuichi Tamagawa]

> I am using MySQL ver 5.0.11 alpha on window
> platform. I need MySQL to store character as utf8
> encoding.
>
> I use syntax below to alter db, and the command
> run successfully
>
> ALTER database test
> DEFAULT CHARACTER SET utf8
>
> However, everytime when i open MySQL front, the
> default character set reset to default instead of
> utf8, and the data which i enter as utf8 encoding
> display as ???

What kind of client are you using?

Client terminal have to support ut8 encoding to display utf8 characters correctly,
and if you are using mysql client from MS-DOS prompt, I doubt it can display utf8 characters.

Try SELECT HEX(column_name) FROM table_name; statement.
You can see if there is data crruption or it's jutst a displaying problem.

By the way, ALTER database test DEFAULT CHARACTER SET utf8 statement does not change anything on the existing table. It only affects the default character set of tables created after that.