Hibernate version: 1.2.1

I'm trying to run an HQL query with a parameter that's compared to an Oracle NCHAR column. The query looks something like



If the bar parameter is set to something like 'bar', and the Oracle NCHAR column is longer than the parameter text, it does not match. It does match if I right-pad the parameter value to the column length.

I've tried this using the same schema (NCHAR column) in SQL Server and it works fine. Using a literal value, like this:



works against the same Oracle database.

I was able to fix it by defining a custom type based on a user type with a DbType of System.Data.DbType.StringFixedLength (not sure why there isn't a standard StringFixedLength type in NHibernate) and then explicitly specifying that custom type whenever IQuery.SetParameter() is called with a string parameter.