Meaningless Drivel is fun!*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
A strange unicode String literal problem
Converting special characters to hex code
Parsing RSS2.0 feeds using XML Pull Parser
Default character encoding?
Displaying char values from 128 to 160