what is Memo for MS SQL ?

[qwer]

in Access a Memo = 64000 char

what is it in MS SQL ? I find only for 255 char

thank you

[rmiao]

Ues text data type, it can hold up to 2g characters.

[qwer]

I have tried it but if I write into entreprise manager just to see, it erase all and write <long text>

thank you

[skhanal]

You can't use regular update statement for text, you have to use WRITETEXT or UPDATETEXT. Enterprise Manager does not display text, You can use READTEXT statement in query analyzer. But you can get first few characters by doing substring on the column.

[qwer]

ok thank you, MS SQL is a very strong database but really it looks somehow antic

[rmiao]

It works different from access.

[Rawhide]

You should use the TEXT data type only when you absolutely need it. A varchar or char field in SQL Server can have a maximum size of 8000 bytes (not to exceded a total row length of 8060). Nchar and nvarchar fields can likewise have a max size of 8000 bytes, but because unicode characters are 2 bytes each, 1/2 as many characters fit into those fields.

As mentioned above, the maximum size for a row of data is 8060 bytes, so your total defined size should not exceed that.

If one of these 4 data types suits your needs, you should use that.

[qwer]

thank you very much