Hibernate version:3.2.1.ga
Spring version:2.0.6

and JPA.

Hi,

My application is working with unicode data and at times I need to do string comparisons with unicode data. According to the Microsoft documentation I need to prefix unicode string literals with N

For example
select * from places where places.neighbourhood in ('Dōngchéng')

needs to be
select * from places where places.neighbourhood in (N'Dōngchéng')


unfortunately when I attempt put this literal into the JPA query string I get the following error:

org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 'city centre' near line 1, column 148 [SELECT poi from au.com.worldguide.model.Poi poi WHERE poi.destination.id = ? AND poi.poiType.id = ? AND poi.addressNeighbourhood IN (N'city centre', N'CBD', N'Neighbourhood', N'Darlinghurst', N'Paddington') ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 'city centre' near line 1, column 148 [SELECT poi from au.com.worldguide.model.Poi poi WHERE poi.destination.id = ? AND poi.poiType.id = ? AND poi.addressNeighbourhood IN (N'city centre', N'CBD', N'Neighbourhood', N'Darlinghurst', N'Paddington') ]
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 'city centre' near line 1, column 148 [SELECT poi from au.com.worldguide.model.Poi poi WHERE poi.destination.id = ? AND poi.poiType.id = ? AND poi.addressNeighbourhood IN (N'city centre', N'CBD', N'Neighbourhood', N'Darlinghurst', N'Paddington') ]

It appears to have an issue with the N, is there anyway around this?

I must be missing something...

Okay I've solved my problem,

I was manually constructing the "in" clause using code similar to the following:
queryString.append("select * from places where neighborhood in (");
for (string string: Neighborhoods)
{
queryString.append("'"string+"', ");
}
queryString.append(")";

(note that's not the code I was using, but you should get the gist).

anyway I've since updated my code to pass all the variables used within the query as query parameters which has resolved my problem.

This was a valuable lesson for me, send everything down to the database as a query parameter.

:)