• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Building generic search for multilingual data with oracle database

 
Ranch Hand
Posts: 37
MyEclipse IDE Oracle Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic