Problem inserting data into db Microsoft ODBCSQL server drive SQL server

Asked By t.andy 20 points N/A Posted on - 03/16/2012

 “Problem inserting data into db Microsoft ODBCSQL server drive sql server” Hello This error message arises if I have inserted particular characters or a huge name in the registrant name section on the Software page and Forms. Then to approve it, I cut down the name to fewer than 50 characters and confirm that the name does not hold any particular characters. But I want to insert more than 50 words. What should I do?

Need your help. Thanks.

• Status: Open
• Question Views: 939
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Estillero State 5 points N/A #99656

Problem inserting data into db Microsoft ODBCSQL server drive SQL server

Hi T.Andy,

Try modifying the column width of the affected table in the MS SQL server. You can easily do this by using the SQL Server Management Studio. You have to have access to the database server though. You can also execute a DDL to do it. Just simply execute this command:

alter table <your_table> modify <your_column> VARCHAR(SIZE)

You have to change the column's data type to VARCHAR if it not yet a VARCHAR. Remember you don't know the size of the data you want to insert. VARCHAR can handle that because of its characteristics. It will automatically adjust to the data provided that it is not greater than the SIZE specified. You may refer to this site for more info about the VARCHAR data type.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/char-and-varchar-transact-sql

 

I hope it helped.

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/17/2012
• Question Category: MS SQL Server