[TYPO3-dev] dbal with SQL Server 2000, value type mismatch when saving records in backend

[Robert Böttner]

Hi list,

we have to switch to MS SQL Server 2000 in an intranet installation of 
TYPO3. We are running the server on a Debain Sarge machine with unixODBC 
and FreeTDS as the driver. TYPO3 is 4.1.3 with the latest versions of 
ADOdb and dbal. The suggestions on the Wiki 
(http://wiki.typo3.org/index.php/Mssql) were very helpful. So far the 
installation works except when trying to store records in tables with 
binary fields. The fields were created as field type image in SQL Server 
but all tests with the other possible field types (binary oder 
varbinary) also fail:

These fields are not properly updated in database: (config) Probably 
value mismatch with fieldtype.

Has anyone experience with a MS SQL Server setup?

Kind regards
Robert.