wood burning stoves 2.0*
The moose likes JDBC and the fly likes Building generic search for multilingual data with oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Building generic search for multilingual data with oracle database" Watch "Building generic search for multilingual data with oracle database" New topic
Author

Building generic search for multilingual data with oracle database

Arvind Gangwar
Ranch Hand

Joined: Mar 25, 2010
Posts: 37

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.


Arvind Gangwar
OCPJP 6
Sudheer Bhat
Ranch Hand

Joined: Feb 22, 2011
Posts: 75
Arvind,

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

Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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
 
subject: Building generic search for multilingual data with oracle database