Column length change on SQL Server 2005

I changed field length named 'State' from nvarchar(1) to nvarchar(10). Works properly on Server side.

But on client side (I use Delphi7 and connect with Adoquery) there is a problem after insert a record.

Client send 'Active' text to server but on server side it seems at table only 'A' character, not 'Active'.

Could anyone help ?

Answers

You will have to change the property Size of your published field State to 10. If you are sending data per parameterized queries you will have to adapt the Size of the parameters.

Need Your Help