Delphi7+ADO+MySQL5.1 ODBC Driver
Hi to all. (sorry for my english :) )
I have Delphi7, MySQL 5.1 on localhost, MySQL ODBC 5.1 Driver, and using ADO components for connection.
MySQL:
default character set=latin1
table `A` - engine MyISAM, CHARACTER SET cp1251
field_1 int not null AUTO_INCREMENT
field_2 varchar(20)
PRIMARY KEY(field_1)
Problem:
If table `A` is empty - everything OK, but if there is at least one row, then i have "The supplier of information or other service returned the state of E_fail"(approximate translation) error when make ADOTable.active:=true.
But if table `A` have UTF8 or latin1 CHARACTER SET, then i have no problems.
I tried add "SET CHARACTER SET CP1251" to my connection string:
Provider=MSDASQL.1;Extended Properties="DRIVER={MySQL ODBC 5.1 Driver};user=someuser;password=somepass;DATABASE=somedb;OPTION=3;INITSTMT=SET CHARACTER SET 'CP1251';" but it does nothing!
If in connection string write "charset=cp1251" then i have "Access violation" in myodbc5.dll.
I know i can use UTF8, but i need cp1251, and using of UTF8 will be last step, if i don't found another solution.
Anybody know how to fix it? Thanks.
Subject
Written By
Posted
Delphi7+ADO+MySQL5.1 ODBC Driver
August 09, 2009 05:12AM
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.