Jag vill lägga till text i en sql databas men antal tecken är begränsat till varchar - 8000
ny har jag två texter jag vill lägga in som är på över 10,000 tecken med blanksteg.

Hur gör man då??

Använd BLOBs...


/Emma


utdrag ur SQLBol:
-----------8<-----------8<-----------8<-----------8<-----------8<-----------8<-----------8<----------
Repository engine provides interfaces to handle properties that are binary large objects (BLOBs) and large text fields. BLOBs are properties that have values containing text or image data that can be in excess of 64 kilobytes (KB). You can use BLOBs to perform database operations that require you to work with large segments of data at a time.

To define a BLOB, create a PropertyDef object, and then do the following:

Set the SQLType property to SQL_LONGVARBINARY or SQL_LONGVARCHAR.


Set the SQLBlobSize property to a value greater than 64 KB.
When SQLType is set to either SQL_LONGVARBINARY or SQL_LONGVARCHAR, SQLBlobSize (rather than SQLSize) determines the maximum size.

To work with a BLOB, use the IReposPropertyLarge interface. This interface provides methods that support BLOB manipulation. Specifically, it can be used to read, write, move, and seek information about a BLOB.
-----------8<-----------8<-----------8<-----------8<-----------8<-----------8<-----------8<----------