MySQL Bugs: #44650: BLOB field problem using ADO component in Delphi

Bug #44650	BLOB field problem using ADO component in Delphi
Submitted:	4 May 2009 19:42	Modified:	5 May 2009 12:23
Reporter:	Primož Jereb	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	MySQL 5.1.33	OS:	Windows (sp3)
Assigned to:		CPU Architecture:	Any

Description:
Hello!

I was using mysql database with no problems till now. I have created a table with two fields. One field is BLOB type the other is VARCHAR. I'm using ADOTable component to view data in Delphi. Everythink works fine when fields of type VARNAME are empty. When I fill VARNAME fields wit some string value I got error "E_FAIL" when I try to activate ADOTable. Any suggestions what might be wrong?
Thank you for the replies...

With Kind regards, Primož!

How to repeat:
Error is repeating constantly with table described above.

Hi Primož and thanks for your report.

Any number of things can be wrong here and I think you'll find many similar bug reports in BugsDB. For example, Bug#37345, Bug#36373, Bug#37127, well, much easier would be to follow the link:
http://bugs.mysql.com/search.php?search_for=Delphi&status=All&severity=&limit=10&order_by=...
and find most similar one.

In case you think your problem is much different than all of those, then please do the following:
  o Describe your environment, starting with Delphi, ADO and c/ODBC versions
  o Attach complete (even DDL/DML) but small Delphi test case I can load
  o Attach ODBC trace file you get after running test case

Tonči

Hello... 

I solved the problem. First I have created table with query you've posted in #28065. ADOQuery (SELECT * FROM tst1) worked nice on that table. So if it worked there it should work on my table too because they are quite similar. Problem was in collation. I did not define collation on VARCHAR field. It works now with utf8_general. I also tried with cp1251, but it didn't worke once again. Collation also need to be set on DATETIME field. 

Thanks for your help, Primož!

Primož, so I can close this now?

Fine by me, thanks again!

LP, Primož!

No problem.