Home.... | log in.... | Pub my question! | Sign-up....

dbmultilingual utf-8 encoded sites

Hi,

I'm currently working on a site where I've been asked to build multilingual support in terms of accepting foreign characters in inputs and properly render foreign chars in html, xml etc . The main concern is that the database that pull all data for this site is using ISO8859-1 as charset (Oracle 10G). Unfortunately it's not possible in the short time to convert the database to utf-8. Is it still possible to successfully setup a site supporting foreign chars with webpages encoded as utf-8 but having a database using ISO8859-1. What should I think of in getting this to work. For example do I need to convert between charsets when users submit html form data? What possible problems will I encounter and what should I think of in getting this to work

Many thanks

[800 byte] By [Erik_Lindgrena] at [2007-11-27 2:38:15]

«« Exception e.getMessage()
»» Getting Polygon out of the Area

# 1

Reading data from the database into your Java code will automatically do the decoding from ISO-8859-1 bytes into Unicode characters, and likewise writing to the database will do the necessary encoding. So as long as these "foreign" characters are characters that exist in ISO-8859-1, there should be no problem there.

DrClapa at 2007-7-12 2:59:16 >

# 2

Hi,

Thanks for your reply. The aproach this company has taking up until today is to escape all "foreign chars" into corresponding html character references and store those together with normal ascii text in the database. Likewise all foreign chars in the output are rendered with corresponding html char references. I 'm not very familiar using this method so I'm wondering if there any significant limitations/disadvantages escaping characters in this way and especially in context of generating xml for exchanging data with other systems.

Thanks

Erik_Lindgrena at 2007-7-12 2:59:16 >

# 3

>I'm wondering if there any significant limitations/disadvantages escaping characters in this way and especially in context of generating xml for exchanging data with other systemsThis actually makes life easier for you, so pick up a book on HTML and start reading it

viravana at 2007-7-12 2:59:16 >

Desktop

I18N

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

dbmultilingual utf-8 encoded sites

Desktop New Topic

Desktop Hot Topic

Desktop

All Classified