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]
