title: How to set encoding in fluent NHibernate?
body: <p>I have created my database by this sql query:
    <code>("CREATE DATABASE " + DBName + " DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci", connection)</code></p>
  
  <p>And I have this fluent configuration:</p>
  
  <pre><code>Fluently.Configure()
                       .Database(MySQLConfiguration.Standard.ConnectionString(c =&gt; c.Server(server)
                          .Database(DBName).Username(username).Password(password)))
                       .Mappings(m =&gt; m.FluentMappings.AddFromAssemblyOf&lt;Program&gt;())
                       .BuildSessionFactory();
  </code></pre>
  
  <p>How can I set NHibernate encoding in this configuration? or how can I set my mappings encoding?</p>
  
  <p>I want to this because when I want to select with a property which has UTF8 encoding NHibernate sql will include ??????? in strings with encoding</p>