Why MS Visual Studio passes empty spaces to SQL Server columns?

Question

I am developing a Library Management System using Visual Studio 2015 as a front end and Microsoft SQL Server 2014 as back-end to store data.

This is my table design:

But when I try to pass data from Visual Studio, it saves as blank spaces to the defined length.

For example if store a text contain 10 characters on title remaining 490 store as blank space.

The highlighted are the blank space in the column. If I set the length 10 which is default I cannot store data more than 10

Is there any solution for this? is this a issue on my database or Visual Studio?

Answer 1

You're using the wrong data type. nchar is fixed length. You need to use nvarchar (variable length).