NHibernate String Mapping to UTF8

Question

i am using NHibernate together with a Firebird Database and are not sure if the String-Types are mapped correctly. In .NET a String-Type is normally UTF16 encoded. In Firebird i have defined my Domain wie Character Set UTF8.

So if i have this Domain-Class:

public class Project
{
    public virtual Int64 ID { get; set; }
    public virtual String Name { get; set; }
}

and this NHibernate Mapping:

<class name="Project">
<id name="Id">
  <generator class="sequence">
    <param name="sequence">MY_GEN</param>
  </generator>
</id>
<property name="Name"/>
</class>

Does NHibernate automatically converts my System.String to a Firebird UTF8 String in this case? It seems to be ok in the database. But i am not sure about the handling in NHibernate.

It is misleading to say "In .NET a String-Type is normally UTF16 encoded", as encoding refers to the serialized form. A string is not that; a string is raw Unicode code-points - quite different. Normally, the ADO.NET driver (or other driver) will be responsible for this step - in most cases I would not expect the ORM tool to have anything to do with encoding. — Marc Gravell
– Marc Gravell, Commented Sep 15, 2012 at 9:59

Martin Ernst · Accepted Answer · 2012-09-17 13:55:21Z

1

The default string type for NHibernate saves the data using DbType.String (which is a Unicode string). Firebird will encode the unicode string in UTF8 for you.

The alternative (without getting into custom types) would be to specify an AnsiString type which would also work with UTF8 if all you used was ASCII characters.

Since you're not specifying the type, NHibernate will use it's StringType and it will work properly.

answered Sep 17, 2012 at 13:55

Martin Ernst

5,6992 gold badges20 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NHibernate String Mapping to UTF8

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related