Hi,

I have problem with charset (MySQL + Delphi).
------------------------------------------
SET CHARACTER SET cp1250_latin2;
SELECT * FROM en1 WHERE en1 LIKE 'worm';
------------------------------------------
This query works right in PHP and command line (Linux, Windows),
but in Delphi7 (Kylix3) line "SET CHARACTER SET cp1250_latin2;" does'nt
work.
It's No error notify, but it returned text in ISO-8859-2.


Here is my code in Delphi (dbExpress) ...
------------------------------------------
//1 possibilty
SQLConnection1.Execute('SET CHARACTER SET latin2_cp1250',nil,nil);
//2 possibility
//SQLDataSet1.CommandText := 'SET CHARACTER SET latin2_cp1250';
//SQLDataSet1.ExecSQL(TRUE);
sql := 'select * from  where en1 +' like ''' + Edit1.Text + ''' order by ' +
RadioGroup1.Items[RadioGroup1.ItemIndex];
SQLDataSet1.CommandText := sql;
SQLDataSet1.Open;
-------------------------------------------

Pleasse, how can I change charset for MySQL data in Delphi?

Thanks

Milos Vymazal
http://garten.cz


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to