OT : Convert Korean Access mdb to MySQL

[Eric Noel <er...@mylife.ph>]

im trying to convert an access file to mysql db
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org