Store text in SQL CE

Question

Wich datatype should I use in my SQL Server Compact Edition table to store text over 4000 chars?

I thought ntext was it, but then I read something about storing images there.
Is ntext the eqvalent to Text (as in mysql databases).

Answer 1

You are right - it's NTEXT. To store byte arrays larger than 8000 bytes use the IMAGE data type.

---

João Paulo Figueira (Device Application Development MVP)