0

I am wondering;

  1. Why does Microsoft SQL Server not support a full text index on a NVARCHAR(MAX) column?
  2. Why is it limited to 900 bytes?

Any insights?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
jersoft
  • 478
  • 2
  • 9
  • 20
  • 5
    The full text search field could be `nvarchar(max)`, but any index in SQL Server is limited to 900 bytes. Check out this [answer](https://stackoverflow.com/questions/12717317/900-byte-index-size-limit-in-character-length#12717441) – gofr1 Jul 25 '16 at 08:14
  • 1
    Why? Because Microsoft decided to design the software that way. –  Jul 25 '16 at 09:25
  • 1
    @a_horse_with_no_name thats why im wondering, and yes, microsoft design the software that way, i know that too, thanks for you helpful comment! XD – jersoft Aug 02 '16 at 07:25

0 Answers0