Re: utf8 character show as ???

[Shachi Rai]

Hi,

I making a j2ee application and using MYSQL as a backend. The application requires me to save special characters like alpha , Beta etc... for which we are using unicode
Right now i can see the data correctly in the JSP.

But when i see the record data in the data base it comes up as corrupted.

I m using MySQL version 4.1 ... and MySQL Client CC.
probably there is character set issue...

I have made the following settings

1) default-chararcter-set=utf8 in my.ini file
2) default-collation=utf8_general_ci my.ini file
3) [mysqld] init_connect='SET NAMES utf8' my.ini file
4) created the table with default charset as utf 8

Still on querying the data base through MYSQL CC ... i do not get the correct symbol . Infact it shows ω ,øΩ whereas I had given the data as alpha, Beta and omega ....


Can you please help...

it is very urgent

Thanks in advance