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
