Query-based insertion or updating of BLOB values is not supported.-- ????

One of our clients has data on their internal SQL Server which they will
be sending to our webserver periodically using the MySQL ODBC driver. In
the testing we've done so far we've had problems with large character
fields.

In MySQL the problem columns are defined as type TEXT, which is reported
to SQL Server as a LONG VARCHAR. On their end these columns are defined
as nvarchar(2000).

Any INSERTs they attempt to have their system perform on our MySQL
server using data from one of those columns gives them this error:

"Query-based insertion or updating of BLOB values is not supported."

What do we need to do to make this work?

Thank you,

-- Jordan Bradford
----------------------------
BrownBoots Interactive, Inc.
108 South Main St.
Fond du Lac, WI 54935
920-906-9175
http://www.brownboots.com/

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org