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

[Martin Kutschker]

Robert Böttner schrieb:
> 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.

Does the update really fail or is it "just" an error message in the BE? 
On other DBs there were issues like this where it turned out that the 
check is for some reason wrong but the statement itself was ok.

Masi