Data (string) being truncated when written to an SQL table
Posted on 2003-10-29
SQL 7 & Access 2000
I have a problem that I an trying to sort out at teh moment.
I have an SQL table defined with in SQL terms it has a datatype of Ntext length of 16, which in effect appears to mean a very large field up to 64K in size I think. In terms of a MS-Access Table thsi field would be a Memo datatype.
My interface take this field and displays it in a Text box in an Unbound form. The entire field data is successfully retrieved and displayed. If however the field data length is greater than 250 characters (lets say 400), and I want to update this field byt typing in the extra data, then when the data gets written back to teh SQL table, it gets truncated at 250 chars.
The update is done using an SQL statement
update <table> fieldname = "......", where key = xxxx
The update appears to work successfully, however when you next look at the data the information is truncated as 250 characters.
Am I missing anything obvious here?