MySQL + Delphi(Kylix) kodovani cestiny

[Milos Vymazal]

Ahoj,

mam problem s konverzi z MySQL v Delphi (Kylixu).
MySQL to klopi bez problemu, ale dbExpress to nechce chapat.
---------------------------------------------------------
SET CHARACTER SET cp1250_latin2;
SELECT * FROM en1 WHERE en1 LIKE 'worm';
----------------------------------------------------------
Tohle funguje v PHP i v prikazovem radku v Linuxi i ve Windows.
Delphi radek SET CHARACTER SET cp1250_latin2 naprosto
ignoruje a vraci mi to ve Windows v ISO-8859-2. Pres MyODBC
se to klopi spravne.

Takhle se o to pokousim ...
------------------------------------------
//1 pokus
SQLConnection1.Execute('SET CHARACTER SET latin2_cp1250',nil,nil);
//2 pokus
//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;
-------------------------------------------

Dik za kazdou radu.

Milos Vymazal
http://garten.cz