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/1994<p>nvachar(42) :-)</p>Reguel WermelingerMon, 29 Aug 2016 11:08:20 -0400https://answers.axonivy.com/questions/1988/nvarchar-max/1994