Re: Hibernate / MS SQL / Unicode

On 2005-11-22, JScoobyCed <pim@xxxxxxxx> wrote:
> JScoobyCed wrote:
>> Hi,
>>
>> I have a web-apps that sends unicode data to my servlet. I can save
>> it ot he MS SQL server and when I read it using JDBC client (Squirrel),
>> I can see the unicode correctly in the DB.
>> I use Hibernate to read/write to the DB.
>> I Hibernate reference docs, I didn't find anything about unicode values.
>> The funny thing is I can save correctly.... but when I try to query it
>> doesn't work.
>> A simple query like
>>
>> session.createQuery("from User where username='xxxxxx'");
>>
>> ( where 'xxxxx' is a unicode String)
>> it returns nothing.
>
> Ok, found the solution...
>
> Have to use "Criteria"
> Criteria criter = session.createCriteria(User.class);
> criter = criter.add(Restrictions.eq("username", usern));
> List list = criter.list();

I'v got the feeling if you use a prepared statement that it will work
too.


--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
.

Relevant Pages