File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Building generic search for multilingual data with oracle database

 
Arvind Gangwar
Ranch Hand
Posts: 37
MyEclipse IDE Oracle Tomcat Server
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am working on project where I am creating a search module, in which data stored in multiple languages in tables(in oracle database reference.)
My module is work fine for English searching, but other language data are showed with rectangle or ?and any other latter.

I created my table with nvarchar2 and nchar data-types and I entered these respective field values with N<column values>.

So Please if any solution then give me suggestion how i implement my module which support multilingual(these may be any Indian language like Tamil, Telugu etc). data search capability.
 
Sudheer Bhat
Ranch Hand
Posts: 75
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arvind,

Have you checked NLS Language Support . This is a good starting point to setup Oracle database to support multiple character sets.

 
Paul Clapham
Sheriff
Pie
Posts: 20188
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arvind Gangwar wrote:but other language data are showed with rectangle or ?and any other latter.


You have told us about the database, but you haven't told us how you "show" the data. That makes it difficult to identify possible problems; you have assumed the problems are with the database, but the problems could also be with your choice of "show" technology.

In general if you see a rectangle, that means you chose a font which can't render the character. If you see a question mark, that suggests you have an encoding problem. However since you only told us about the database and not about where that font is being used or where you might be doing character encoding, it's hard to identify those problems.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic