title: How to map a VARCHAR(MAX) column in NHibernate hbm.xml mapping files
body: <p>We have a SQL Server table with varchar and nvarchar max columns like this:</p>
  
  <pre><code>CREATE TABLE [dbo].[MyTable](
    :
    [MyBigUnicodeColumn] [nvarchar](max) NULL,
    [MyBigAnsiColumn]    [varchar](max) NULL,
    :
  </code></pre>
  
  <p>When creating the mapping (hbm.xml) files, the <a href="http://nhforge.org/doc/nh/en/index.html" rel="noreferrer">documentation</a> says to use StringClob as the type attribute for large objects with a database type of DbType.String, but it doesn't say what to do if the database type is DbType.AnsiString.</p>
  
  <pre><code>&lt;class name="MyTable" table="MyTable" lazy="false"&gt;
    :
    &lt;property name="MyBigUnicodeColumn" type="StringClob" /&gt;
    &lt;property name="MyBigAnsiColumn" type="????" /&gt;
    :
  </code></pre>
  
  <p>This is for NHibernate 3.3.1.</p>