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