derby 的字符集

在DB内部存储的时候，肯定全是unicdoe，但是客户端可不只是java.
控制台上运行ij的时候，最好指定一下字符集。
我改完的shift-jis版本的ij.bat:
:runNoClasspath
"%_JAVACMD%" %DERBY_OPTS% -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=SJIS -classpath "%LOCALCLASSPATH%" org.apache.derby.tools.ij %DERBY_ARGS% %DERBY_CMD_LINE_ARGS%
goto end
:runWithClasspath
"%_JAVACMD%" %DERBY_OPTS% -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=SJIS -classpath "%CLASSPATH%;%LOCALCLASSPATH%" org.apache.derby.tools.ij  %DERBY_ARGS% %DERBY_CMD_LINE_ARGS%
goto end

参考站点：
http://db.apache.org/derby/docs/dev/tools/rtoolsijpropref97949.html

The following command specifies to run ij using the Japanese territory (derby.ui.locale=ja_JP) using Japanese Latin Kanji mixed encoding (codeset=Cp939):
java -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=SJIS
-Dij.protocol=jdbc:derby:
org.apache.derby.tools.ij
The following table contains a sampling of character encodings. Supported encodings vary from product to product. For example, to see the full list of the character encodings that are supported by the Java Platform, Standard Edition 6 Software Development Kit, go to http://download.oracle.com/javas ... /encoding.doc.html.

转载于:https://www.cnblogs.com/johnsonshu/archive/2012/06/28/2568438.html