File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

search special characters with english alphabets

 
Nikhil Menon
Ranch Hand
Posts: 70
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic