Error: data truncated.
Hello,
When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).
String or binary data would be truncated.
The statement has been terminated.
How can I make that at least the first 6 characters will be saved and the
input is indeed truncated without generating an error or at least to catch
the error silently?
Many thanks and greetings,
Michel
.
Relevant Pages
- Re: Critique rules
... the stories you're working on. ... writing cinquentas, for instance. ... and to trust the reader to pick up something ... characters end up, ... (rec.arts.sf.composition) - Re: Critique rules
... things which sharpen one particular skill. ... terms, that would be writing cinquentas, for instance. ... are stories at all, because they lack everything that makes ... For me, a story needs characters in an interesting world, ... (rec.arts.sf.composition) - Re: Character name advice wanted.
... Racefail is unimportant in itself but it is a useful ... the New York Times. ... correctness, of writing to avoid accusations, rather ... slushpile because none of the characters are identified ... (rec.arts.sf.composition) - Re: Rambling: the info (+ experiment on reader reaction)
... That's so opposite of how I feel, even about my own writing. ... writing and revising later on is more like actual revising. ... looking at fanfic stories I wrote in 1980. ... as change some in the first book, to make the characters the way I want ... (rec.arts.sf.composition) - Spuddies March 2007 reads (long)
... Fire epic fantasy series. ... book only deals with about half the characters. ... I love Martin's writing ... style and his "world" and will likely pre-order A Dance With Dragons ... (rec.arts.mystery) |
|