how can i set the encoding when i'm configure nhibernate with fluent configuration on mysql
my problem is that i'm saving hebrew text on db and all i see in my app is ????
+2
A:
I think this is not related to Fluent NHibernate. When you create your database you indicate the encoding:
CREATE DATABASE mydb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Also verify that you append ;charSet=utf8 to your connection string.
Darin Dimitrov
2009-11-22 11:03:18
i create the db through nhibernate...and i tried to add this char set and nothing works..
Chen Kinnrot
2009-11-22 12:07:23
Once the database is created can you verify the collation that is applied with the tool you use to administer your mySQL server (probably `mysqladmin`).
Darin Dimitrov
2009-11-22 12:57:05