I've tried save a Euro Symbol
€ using NHibernate and FluentNHibernate in a database Oracle 11g.
I have checked a log from NHibernate and see the generated sql statement:
SET DESCRIPTION = 'Euro',
SYMBOL = '€',
WHERE ID = 63
When the query from table
CURRENCY execute, the column
I've tried change the FluentNHibernate Mapping for the column
AnsiString, like this:
Map((x) => x.Symbol).Column("SYMBOL").CustomType("AnsiString").Not.Nullable();
But it doesn't work.
I tried too change type of column for
NVARCHAR2 and change FluentNHibernate Mapping for:
Map((x) => x.Symbol).Column("SYMBOL").CustomSqlType("NVARCHAR2").Not.Nullable();
But it doesn't work too.
How can I get it working?