https://answers.axonivy.com/questions/1988/nvarchar-max<p>Hi All,</p> <p>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 ?</p> <p>Best Regards, Yordan</p>enTue, 30 Aug 2016 01:48:11 -0400https://answers.axonivy.com/questions/1988/nvarchar-max/1998<p>Hi Stelt0</p> <p>If you put in the <code>Length</code> with value <code>2147483646</code>, it does give you the column <code>varchar(max)</code>. If you really need to make it <code>nvarchar(max)</code>, you may want to create a Java class (instead of a <code>Data Class</code>) and then you can flexibly configure your <code>@Entity</code>.</p> <pre><code>@Entity public class BlogPost extends CompositeObject { @Column(columnDefinition="nvarchar(max)") public String content; } </code></pre>Genzer HawkerTue, 30 Aug 2016 01:48:11 -0400https://answers.axonivy.com/questions/1988/nvarchar-max/1998https://answers.axonivy.com/questions/1988/nvarchar-max#1996<p>yes: <a href="https://de.wikipedia.org/wiki/42_(Antwort)">https://de.wikipedia.org/wiki/42_(Antwort)</a></p> <p>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.</p>Reguel WermelingerMon, 29 Aug 2016 12:19:23 -0400https://answers.axonivy.com/questions/1988/nvarchar-max#1996https://answers.axonivy.com/questions/1988/nvarchar-max#1995<p>you are joking, right ?</p>Stelt0Mon, 29 Aug 2016 11:49:08 -0400https://answers.axonivy.com/questions/1988/nvarchar-max#1995https://answers.axonivy.com/questions/1988/nvarchar-max/1994<p>nvachar(42) :-)</p>Reguel WermelingerMon, 29 Aug 2016 11:08:20 -0400https://answers.axonivy.com/questions/1988/nvarchar-max/1994