MySQL Forums
Forum List  »  Delphi

Delphi7+ADO+MySQL5.1 ODBC Driver
Posted by: Maks Nazarenko
Date: August 09, 2009 05:12AM

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.

Options: ReplyQuote


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.