Hibernate Community • View topic - Finding entities with ISO-8859-1 characters

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Finding entities with ISO-8859-1 characters

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

xmaniac

Post subject: Finding entities with ISO-8859-1 characters

Posted: Mon Jun 18, 2007 4:04 am

Newbie

Joined: Mon Dec 12, 2005 8:57 am
Posts: 13

Hi,

I would like to query data without explicitly forcing the user to write special characters or caps. For example, querying in a varchar column for jose should retrieve JOSE, Jose, josé or jöse

I'm not sure how to achieve this. I'm using Hibernate as my JPA provider. Do I need Hibernate search?

Regards,

Last edited by xmaniac on Mon Jun 18, 2007 6:50 am, edited 1 time in total.

Top

ouzo

Post subject:

Posted: Mon Jun 18, 2007 5:03 am

Regular

Joined: Wed May 05, 2004 8:01 am
Posts: 53

You cannot achieve this kind of functionality in pure SQL. You probably need some properly configured indexing engine + post commit actions.

Hibernate Search is the right place to start. Even if does not help you implement exactly what you want you can always mimic the code to write your own post commit action (I doubt you will have to do that).

Please rate if that helps.

Top

xmaniac

Post subject:

Posted: Mon Jun 18, 2007 6:50 am

Newbie

Joined: Mon Dec 12, 2005 8:57 am
Posts: 13

In the end, using Oracle proved to be easier. For anyone interested:

Code:

alter session set nls_comp='LINGUISTIC';
alter session set nls_sort='XSPANISH_AI';

Regards

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum