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