Hello, I am having a problem with storing long texts in MS SQL Server.
The maximum field length for varchar is 8000 (as far as I know). How do I store longer texts as such (not as a binary)? I have tried to use a media field (type “image” in Sql Server), but there I can’t insert text from inside Servoy.
Any ideas anyone?
Thanks, Patrick
Use the “TEXT” datatype. You have to define this on the backend using Enterprise Manager.
Hope this helps,
Bob Cusick
That does it. Thanks for that.
How compatible is that sort of datatype? What do I do when I move on to e.g. Sybase? The datatype issue is a bit of a miracle, since every vendor seems to “invent” their own (like “XML” or the like). But that issue with large amount of text is a rather common one, I think…