CODEWITHSUNDEEP
sqltruncated
Matheus Simon
Matheus Simon

Reputation: 696

SQL Update error: spaces truncate strings

I'm having a problem with sql.

When I try updating like this:

UPDATE Event SET name = 'bla bla bla' WHERE id = 2

It gives me this error:

String or binary data would be truncated. The statement has been terminated.

However, when I try updating with one space less, like this:

UPDATE Event SET name = 'bla bla' WHERE id = 2

It works fine. How come? Any inputs on how to go around this error would be appreciated.

Upvotes: 0

Views: 209

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269643

This has nothing to do with the space. The longer string is too long for name.

Look at the definition of name. You'll see that 'bla bla bla' is too long for it. But 'bla bla' fits.

Upvotes: 1

Related Questions