MySQL converting ? to ì

[Dabase]

Hi,

My MySQL seems to be converting ? to ì, any ideas why this is happening?

MySQL version: 4.1


Thanks
Dabase

 

[Dabase]

Hi,

Apologies for the previous thread, it is converting the greek letter 'miu' into ì


Thanks
Dabase

 

[Dabase]

Hi,

After some research on the net, I have gathered that the most probable cause is due to encoding. But I am concerned that if I change the encoding to greek, the database will then stop recognising the english alphabet, is this going to be the case?

Thanks
Dabase

 

[Dabase]

I found some useful info:

This shows the list of character sets currently supported by your version of MySQL:

SHOW CHARACTER SET;

This alters the database, but does not alter existing tables, only tables created after this alter statement will take greek encoding into effect:

ALTER DATABASE db_name CHARACTER SET greek COLLATE greek_general_ci;

This alters the table:

ALTER table tblproducts CHARACTER SET greek COLLATE greek_general_ci;

I am still to test if latin characters (or english alphabet) are not affected by this change

Thanks
Dabase