Ioannis Anifantakis wrote: > 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?
Why don't you change the default encoding of your MySQL server? This is appropriate if you have no other databases that use other encodings for they data. I personally use UTF-8. Put this in your configuration file: [mysqld] init_connect='SET NAMES greek' Or you can issue this statement just after connecting to the server: SET NAMES greek Good luck! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]