NHibernate version:
1.2.1.4000

HQL:
... FROM User u WHERE u.UserName=N'test'

Throw sqlException: Incorrect syntax near 'test'

The generated SQL (show_sql=true):

... WHERE u.UserName=N 'test'

A blank come Between "N" and "test", it is Incorrect.

Sorry can't help because I have no Idea what

u.UserName=N'test'

is supposed to mean. What does the N before the string literal do and on what kind of db?

just curious
Jens

I use sql server 2005 and it support sql like "Select * from User where UserName = N'Unicode'". because we use the character collation need support unicode.

So I want the hql to search user with unicode, but hql do not throw the syntax exception of "u.UserName=N'test' ", but the generated sql is
u.UserName=N 'test'.
it has a space between the N and 'test' and can not run on sql server.

Is it a hibernate syntax validation bug or generated sql bug?

You shouldn't be constructing queries that way anyway. Use parameters instead. The parameter should automatically be passed as an NVarchar to SQL Server, therefore you don't have to worry about the syntax.

"u.UserName = :userName" is all you need. Then just call SetParameter() on your query object.

thanks jchapman ,

your solution solved this problem greatly .