SQL 7 won't save large text field 
Author Message
 SQL 7 won't save large text field
I have an access2000 database that was converted to SQL 7.  When I
update the text fields with ~35,000 characters the data is lost.  If I
use the same code and update with less then 35,000 characters it is
saved.

Any idea what could have happened in the conversion (upgrade wizard)?

Thank you

Sent via Deja.com
http://www.***.com/



Mon, 02 Jun 2003 03:03:40 GMT
 SQL 7 won't save large text field

This probably doesn't help much, but I bet the limit (before it fails) is
32767 (max positive signed 16-bit integer), or maybe a little smaller if
overhead included.

Is your application written in Access?  What code do you use to update the
fields?  How are the fields defined in the SQL Server 7 database?

HTH,
Tore.

Quote:

> I have an access2000 database that was converted to SQL 7.  When I
> update the text fields with ~35,000 characters the data is lost.  If I
> use the same code and update with less then 35,000 characters it is
> saved.

> Any idea what could have happened in the conversion (upgrade wizard)?

> Thank you

> Sent via Deja.com
> http://www.deja.com/



Mon, 02 Jun 2003 08:57:49 GMT
 SQL 7 won't save large text field
Tore is probably on the right track.

My assumption is that the modifications is not done in chunks (appendchunk in ADO),
hence truncation...

--
Tibor Karaszi, SQL Server MVP
Neil's FAQ at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

Quote:

> I have an access2000 database that was converted to SQL 7.  When I
> update the text fields with ~35,000 characters the data is lost.  If I
> use the same code and update with less then 35,000 characters it is
> saved.

> Any idea what could have happened in the conversion (upgrade wizard)?

> Thank you

> Sent via Deja.com
> http://www.deja.com/



Mon, 02 Jun 2003 18:19:15 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Webpage won't show text field but will show calc of text field

2. Saving Rich Text to sql server Text Fields

3. Saving Rich Text to sql server Text Fields

4. Text field won't return all data

5. SQL Anywhere 5.0 won't save changes

6. ODBC SQL won't save after Change.

7. Writing Large Text field to a text File in Stored Procedure

8. Text won't fit in text box

9. SQL Server 'Text' Data Type Field

10. SQL 2000 freezes with large text field

11. Inserting Large Text 200+ Into field in SQL table

12. Sending a large text field to SQL Server


 
Powered by phpBB® Forum Software