aspose file tools
The moose likes JDBC and Relational Databases and the fly likes search special characters with english alphabets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "search special characters with english alphabets" Watch "search special characters with english alphabets" New topic
Author

search special characters with english alphabets

Nikhil Menon
Ranch Hand

Joined: Nov 22, 2004
Posts: 70
I have a situation where I need to search data in DB2 under this condition:

If a person wish to search on a name : Mathew the search results should also return the values where the name is having the latin-1 Supplement characters in that name such as for the character 'a' it should also search for 'a' with a tilde above it or 'a' with a ring above it etc. Has anybody come across such requirements? does some one has any thoughts?
I thought I will have to use Unicode based search on the DB2.. . Or to resolve the various combinations for search in Java itself by creating the Composite Unicode for the Latin-1 Supplement using the Unicode of 'a'. Any ideas? or Any api available for this translation. Please share your thoughts
 
 
subject: search special characters with english alphabets