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

Aptify (.NET CRM Solution) to MailChimp Synchronization

.net

I'm trying to determine what is involved in synchronizing MailChimp, the popular bulk email service, with Aptify, the .NET-powered CRM my company uses. MailChimp supplies a .NET wrapper DLL which ...

Firefox 3.6 plugins fail on Mac?

firefox plugins osx npapi quickdraw

I just upgraded my mac to Firefox 3.6, and now neither of my TIFF Viewing plugins work.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.