Help with insert into a  text field.....

wqclatre used Ask the Experts™
I try to save a long string into a sql server and get
String or binary data would be truncated.

Why? what are I',m doing wrong?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2004
how do you connect (ado,bde,other)?
what kind of field do you have (blob, varchar,..)?
how do you insert your text?

>get String or binary data would be truncated.
sounds like that your field is too small

meikl ;-)
What kind of datafield-type do you use ?

I guess you used the datatype char.
Better use varchar instead (default length = 50, but you can change it to, i guess, max. 8000).


That was the problem.. (I was focusing on the textfield but the error was in another field.)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial