Hibernate / MS SQL / Unicode - JDBC JAVA

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();

--
JSC

On 2005-11-22, JScoobyCed <pim@pam.poum> 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>