title: How to map(NHibernate) a specified PostgreSql type?
body: <p>I have a PK (character (10)), that is mapped like that:</p>
  
  <p>
        
  </p>
  
  <p>The load works fine with npgsql 1.0, the sql generated with loadbyid
  is :</p>
  
  <p><code>SELECT city0_."IDCity" as IDMu1_92_0_ FROM "tblCity" city0_ WHERE
  city0_."IDCity"=E'BR420240'</code></p>
  
  <p>Using npgsql 2.0. the sql generated is :</p>
  
  <p><code>SELECT city0_."IDCity" as IDMu1_92_0_ FROM "tblCity" city0_ WHERE
  city0_."IDCity"='BR420240'::text</code></p>
  
  <p>So, I got ObjectNotFoundException, because that SQL returns 0
  results...</p>
  
  <p>Npgsql developer told-me to specify the exact type to the PK, in that
  case : character(10)...</p>
  
  <p>How can I do that using NH? I tried use <strong>sql-type</strong>, but I think it only
  exist in Hibernate...</p>
  
  <p>Thanks </p>