Here is something from the list archive
Use java.sql.PreparedStatement for creating and executing your queries.
PreparedStatements are simple to use ; they're like template SQL strings
with ? symbols marking all your changeable values to include in the SQL
statement. After creating the PreparedStatement based on the template,
use
its "set...()" methods (such as "setString()", "setInt()") to replace
the ?
symbols with your values. This avoids worrying about character
encodings,
data formats, and enclosing strings with quotes. However, your JDBC
driver
and database must also be able to handle such characters... the Java
language can, but it depends on everything else in your system.
Just try it if you can! You should be able to construct test strings
by
using an input method editor, or by creating strings based on Unicode
characters (based on numeric escape codes such as \u1234 if necessary)
in
JavaScript or by "pre-filling" your HTML with characters appropriate for
your locale.
-Chris
Re: Internationalization Issue
Date: Mon, 20 Aug 2001 15:04:10 +0200
From: chris brown <[EMAIL PROTECTED]>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets