Win a copy of Microservices Testing (Live Project) this week in the Spring 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
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

Language diaplay problem in the UI for other than English

 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello,

My Database has some data in Thai Language. While displaying it in the UI I see only "?" instead of the Thai letters.

This is happening for only one table in the database. Other tables are working fine. I mean it returns and displays the proper Thai name if stored.

Could anyone help?

Thanks,
Namrita
 
Namrita Mohanty
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oops!!! Just to make a small correction.... For other Tables also it isnt working... Thai data from database when tried to display it on the screen shows "?" Question marks....

Sorry... Please help?
 
Ranch Hand
Posts: 662
Eclipse IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
When we are creating tables, we should be specifying the format in which the data is stored in the table. like latin1, UTF-8 etc., Check if the problematic table stores data in different format than others.
 
Namrita Mohanty
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
While it saves data into the Database the correct Thai format is getting saved....

For Eg:

Table: PostalCodes has three columns [Postalcode(numeric english),
District(Thai letters),
City(Thai letters)]

Only when we search for a Postalcode i.e a numeric value it displays the Thai letters of its correcponding District and City in "?". Like if its 3 letters in thai that should come it displays "???" for the District and for City of 7 letters in Thai its 7 Q marks that is getting displayed.

Any ideas?

Cheers!
Namrita
 
Arun Kumarr
Ranch Hand
Posts: 662
Eclipse IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
you said other tables are working fine. Considering other table data are getting displayed in other pages, can you go to one of the "correctly displaying page" and retrieve from the same table (say district and city) and try displaying it.

If it displays correctly we can be sure something is wrong in the way the data is handled in UI and clear doubts on the table and wrong data part.
 
Bartender
Posts: 2270
20
Android Java ME Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You probably need to encode it while displaying.
http://download.oracle.com/javase/1.3/docs/guide/intl/encoding.doc.html
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic