AFAICT it works fine, except for a problem with the DECIMAL type. Its implementation has changed in MySQL 5, therefore when trying to retrieve data from a table in a mysql5 database which has a column of type DECIMAL(10,2) I get the following error:
"Using unsupported buffer type: 246" [3 Oct 2005 14:25] Alexey Stroganov
Due to fact that 4.1 client library does not support MYSQL_TYPE_NEWDECIMAL
added in 5.0, and there is no way to disable new DECIMAL type on server side the
only possible solution to avoid reported problem will be relink application that
uses PS C API with the client library from 5.0 server distribution. This fact
should
be noted in Upgrade section in our manual. C API Changes:
Incompatible change: Because the MySQL 5.0 server has a new implementation of the DECIMAL dat
+a type, a problem may occur if the server is used by older clients that still are linked against M
+ySQL 4.1 client libraries. If a client uses the binary client/server protocol to execute prepared
+statements that generate result sets containing numeric values, an error will be raised: 'Using un
+supported buffer type: 246'
This error occurs because the 4.1 client libraries do not support the new MYSQL_TYPE_NEWDECIM
+AL type value added in 5.0. There is no way to disable the new DECIMAL data type on the server sid
+e. You can avoid the problem by relinking the application with the client libraries from MySQL 5.0.
|
(4)
]
