Win a copy of Escape Velocity: Better Metrics for Agile Teams this week in the Agile and Other Processes forum!
  • 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
  • Liutauras Vilda
  • Tim Cooke
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Frank Carver
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • fred rosenberger

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: 27375
88
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.
 
What could go wrong in a swell place like "The Evil Eye"? Or with this tiny ad?
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic