Delphi and MySQL (Encoding Problems)

------=_NextPart_000_0096_01C68966.FACDD220
Content-Type: text/plain;
charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

Hello,

I have been using MySQL version 4.0 because I have experienced problems =
since version 4.1 and later versions...

I tried to update to version 5.0 but problems remain, in short....

Due to my stupidity I had been using latin1 encoding for my database =
even though everything seemed quite smooth. Data stored was retrieved =
fine and my Delphi applications (Delphi 5) run perfectly...

When I dumped my database I took some steps on the resulted .sql backup =
file and managed to turn the database into greek encoding by specifying =
the encoding in on the table definitions of the backup file. =20
I set "/*!40101 SET NAMES greek */;" on the header and "ENGINE=3DMyISAM =
DEFAULT CHARSET=3Dgreek;" at the end of every table definition.

That way managed to get the data running smoothly for the specified =
"greek" encoding through some MySQL management utilities that connect to =
MySQL on version 5.0, so I assume I have correctly turned into GREEK =
encoding.

The problem occures in DELPHI. Whenever I perform a select statement =
the result is that whenever there is a Greek character appears as the =
char(63) or "?". There is one "?" per greek char (not two "??" per =
greek char, so we can assume utf8).

I seem to be unable to find any sources about delphi on how to specify =
an encoding, and I would like to know if there is a way arround that =
problem.

I had to roll back to version 4.0 of MySQL so that my utility runs =
correctly...
Please any advice?
------=_NextPart_000_0096_01C68966.FACDD220--