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. I set "/*!40101 SET NAMES greek */;" on the header and "ENGINE=MyISAM DEFAULT CHARSET=greek;" 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?