schauder wrote:
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?