Re: Query-based insertion or updating of BLOB values is not supported. -- ????
Jess Balint <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
On Thu, May 10, 2007 at 09:24:43PM -0500, Jordan Bradford wrote: > 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." I'm not sure exactly what would cause this, but have you tried enabling the "Don't optimize column width" option on the MySQL DSN? It seems to have worked as mentioned in this bug report: http://bugs.mysql.com/bug.php?id=12446 Jess -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]