Bug #25263 Memo/text Updates fail in Access

Description:
The edited record is not saved. An error message appears:

ODBC -- update on a linked table 'table_name' failed.
[MySQL][MyODBC 5.00.10] Function sequence error (#0)

How to repeat:
- uninstall any previous MySQL ODBC through Add/remove programs
- install MySQL ODBC 5.00.10beta
- create ODBC connection through Administrative Tools->ODBC Connection
- create a nerw database in Access 2003
- link tables with cyrillic unicode data from the created ODBC
- open table
- the Cyrillic letters are now displayed corectly (no ???? signs)
- try to edit some cyrillic record
- go to new record

The edited record is not saved. An error message appears:

ODBC -- update on a linked table 'table_name' failed.
[MySQL][MyODBC 5.00.10] Function sequence error (#0)

Message pop-up

Attachment: message.JPG (image/pjpeg, text), 14.32 KiB.

One more thing i noticed - this bug appears when you try to edit ANY record that contains text/memo fields. If the record contains only numeric fields, the edit is successful.

Ross - Thanks for your report. Can you please share your table schema and an ODBC trace log? Thanks!

Faulty table

Attachment: wtmactions.sql (application/octet-stream, text), 2.25 KiB.

>Ross - Thanks for your report. Can you please share your table schema
>and an ODBC trace log? Thanks!

I just attached a .sql that contains the essence of problem. Just create a new database and use this sql to create a table.
When you try to edit records it throws about 3 different errors (function unknown error, general error, sequence error etc..). Just test with Access 2003 (LINKED table).

Will wait for your help.

Let me vote for this bug too.

Server is "mysql  Ver 14.12 Distrib 5.0.30, for pc-linux-gnu (i486) using readline 5.2"

Client is Access 2003 through "MySQL Connector/ODBC 5.0"

Utf8 data+collation columns with greek characters are displayed/sorted correctly in Access. Altering any record outputs following message (slighlty different from original submission)

ODBC--update on linked table '<blabla>' failed.
[MySQL][MyODBC 5.00.10] General error (#0) [MySQL][MyODBC 5.00.10] General error (#0)

Changed title. This bug is *totally* unrelated to Unicode handling.

Fixed up SQLParamData/SQLPutData to work well with Access. Committed in rev#778.