ADOConnection with ODBC5.1 is collation dependant?
Delphi 2009. Simple Application with DBGrid showing records from ADOTable. ADOTable.ConnectionString is
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER={MySQL ODBC 5.1 Driver};UID=user;DATABASE=test;OPTION=3;PORT=3306;SERVER=localhost;charset=utf8;password=password;"
Database test uses utf8 as charset.
If the collation is set to utf8_general_ci then the display on on DBGrid is messed, all non ascii characters are shown as a pair of chars.
If the collation is set to something specific like utf8_bin_ci, utf8_unicode_ci or utf8_polish_ci then the data are displayed properly on DBGrid.
Why?
Subject
Written By
Posted
ADOConnection with ODBC5.1 is collation dependant?
April 13, 2009 08:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.