Incorrect string size Delphi 2007 & SQL Server 2008 Express

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
comnet
Posts: 5
Joined: Tue 13 Jan 2009 15:22

Incorrect string size Delphi 2007 & SQL Server 2008 Express

Post by comnet » Tue 13 Jan 2009 15:35

Hello,

I'm testing an application with dbexsda ver. 4.45.0.13 using Delphi Win 32 2007 end Microsoft SQL Server 2008 Express.

The field named "Testata" is a varchar(25).

When I try to update the field with a string containing more then 22 chars I receive en error like you can see in the following monitor output.

Begin: user "Sto", server "SQL2008"
update Venduto set
Testata = ?
where
IDVendita = ?
:1 (String[23],IN) = '12345678901234567890123'
:2 (Int32,IN) = 50

String or binary data would be truncated.
The statement has been terminated.
select
IDVendita
from Venduto
where
IDVendita = ?
:1 (Int32,IN) = 50

Rollback: user "Sto", server "SQL2008"

Could you help me ?

Thanks,
Davide

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 14 Jan 2009 08:39

Thank you for information. We have fixed this problem. This fix will be included in the next DbxSda build.

Post Reply