so i decided to use jdbc/odbc to access mdb then insert them to mysql and display first to see if my jsp (see code below) can really fetch korean characters. but it seems it doesnt, how come it display ????|??? instead of the korean characters? do i need to install korean access driver? but i take a look at the mdb using access ide, ican see those korean chars? Thanks for anyone help
----snppied code---
<%@ page contentType="text/html; charset=UTF-8" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"; %> <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"; %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"; %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"; %>
<sql:setDataSource var="mdb"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:convert_db"
user="Admin" password="" /><sql:query var="rs" dataSource="${mdb}">
SELECT * from koreanTbl
</sql:query><c:if test="${rs.rowCount > 0}">
<c:forEach var="row" items="${rs.rows}" varStatus="lineInfo">
<%-- show records fetched --%>
*
<c:out value="${row.fld1}" escapeXml="false"/>|
<c:out value="${row.fld1}" escapeXml="true"/>|
<c:out value="${row.fld1}" />|
<c:out value="${fn:escapeXml(row.fld1)}" /><br />*
</c:forEach>
</c:if>--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
