nvarchar(max)

Question

Hi All,

What is the recommendation for having column like nvarchar(max) ? what should I put in the Length value in the designer when creating Entities nvarchar(max) ? 2147483647 maybe ?

Best Regards, Yordan

Accepted Answer

Hi Stelt0

If you put in the Length with value 2147483646, it does give you the column varchar(max). If you really need to make it nvarchar(max), you may want to create a Java class (instead of a Data Class) and then you can flexibly configure your @Entity.

@Entity
public class BlogPost extends CompositeObject {

    @Column(columnDefinition="nvarchar(max)")
    public String content;

}

Answer 2

0

nvachar(42) :-)

link

answered 29.08.2016 at 11:08

Reguel Werme... ♦♦
9.4k●3●19●58
accept rate: 70%

you are joking, right ?

(29.08.2016 at 11:49) Stelt0

1

yes: https://de.wikipedia.org/wiki/42_(Antwort)

but to really answer the question: you have to estimate the maximum length that will ever be used for that field. But that depends on your domain and can not be answered without knowledge about it. Choosing the maximum possible length will worsen your db performance.

(29.08.2016 at 12:19) Reguel Werme... ♦♦

nvarchar(max)

Follow this question

Related questions