Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

**mrvora** · October 20th, 2009, 04:54 AM

Hi,

Till now our application was using Chinese and Thai characters. We used GB2312 charset and it worked verywell. But now we have got requirement to add vietnamese characters aswell. I tried different combinations of charactersets. Main concern is report generaion which will have all characters in single report. With UTF-8, Vietnamese comming correctly. With GB2312, chinese and thai coming out correctly.

Any solution to this where i can disply Vietnamese,chinese and thai characters in single report. We have JSP which generates report.

Sample Code:
<%@ page language="java"
import="javax.ejb.*,
javax.naming.*,
com.rmisasia.reports.*"
contentType="application/vnd.ms-excel"
%>
<html xmlns

="urn:schemas-microsoft-com

ffice

ffice"
xmlns

="urn:schemas-microsoft-com

ffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html;charset=GB2312">
.
.
.
.
ps = con.prepareStatement("SELECT * FROM TMP_ALL_NAMETYPE ORDER BY SEQ_NO");
rs_alltype =ps.executeQuery();
while(rs_alltype.next())
{
/////Here some cell will have chinese, SOme will have thai and some will have VIETNAMESE column data.
}

ANY CHANGES REQUIRED AT DB SIDE?

Appreciate response of expert.

**Json** · October 21st, 2009, 03:20 AM

You would have to ensure all your layers support the character set you need.

So the database, the internal code that handles the data as well as the jsp page all need to have support for the character set.

// Json

**mrvora** · October 21st, 2009, 03:23 AM

Thanks for Replying Json.

You are right. But what i want to know is that which charset supports all of these languages.

**Json** · October 22nd, 2009, 03:39 AM

Should UTF-8 not work for this?

// Json

**mrvora** · October 22nd, 2009, 03:42 AM

Nope...UTF-8 is not working....

**Json** · October 22nd, 2009, 02:47 PM

UTF-16?

However I though UTF-8 would cover most or even ALL characters on the face of the planet

// Json

**mrvora** · October 22nd, 2009, 07:39 PM

I think not. Try generating sample JSP and use UTF-8 to store chinese and vietnamese chars.

**Json** · October 23rd, 2009, 02:35 AM

Hang on now, from reading your post at the top you're saying that using UTF-8 your JSP wont show correctly, even if you set the meta tag to use content-type and charset for UTF-8?

Have you made sure your application uses UTF-8 as default content type when sending back the response to the browser for .jsp files?

Here is a web.xml example for servlet spec 2.5, this needs to go at the bottom of the file, just before the main closing tag.

		<jsp-property-group>
			<url-pattern>*.jsp</url-pattern>
			<page-encoding>UTF-8</page-encoding>
			<trim-directive-whitespaces>true</trim-directive-whitespaces>
		</jsp-property-group>

// Json

Thread: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

LinkBack

Thread Tools

Display

Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Related threads:

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Re: Vietnamese Character Problem in JSP Report. Chinese and Thai Char OK

Similar Threads

instead of printing in the client, report get printed in the server

Certain Chinese Characters not displayed properly.

[SOLVED] Getting Exception " java.util.InputMismatchException" in scanner package

Program to convert Hexadecimal to its Character equivalent

How to read character from image area(jpg image)?