Java DB

Apache Derby

Derby Tools and Utilities Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Tools and Utilities
-Copyright
-License
-About this guide
-What are the Derby tools and utilities?
-Using ij
-ij properties reference
-ij commands and errors reference
-ij commands
-Absolute command
-After Last command
-Async command
-Autocommit command
-Before First command
-Close command
-Commit command
-Connect command
-Describe command
-Disconnect command
-Driver command
-Elapsedtime command
-Execute command
-Exit command
-First command
-Get Cursor command
-Get Scroll Insensitive Cursor command
-Help command
-Last command
-LocalizedDisplay command
-MaximumDisplayWidth command
-Next command
-Prepare command
-Previous command
-Protocol command
-Readonly command
-Relative command
-Remove command
-Rollback command
-Run command
-Set Connection command
-Show command
-Wait For command
-Syntax for comments in ij commands
-Syntax for identifiers in ij commands
-Syntax for strings in ij commands
-ij errors
-Using the bulk import and export procedures
-Storing jar files in a database
-sysinfo
-dblook
-SignatureChecker
-Trademarks

 

CODESET values for import and export procedures

Import and export procedures accept arguments to specify codeset values. You can specify the codeset (character encoding) for import and export procedures to override the system default.

The following table contains a sample of the character encoding that is supported by JDK 1.x. To review the complete list of character encodings, refer to your Java documentation.

Table 1. Sample character encodings. This table contains sample character encodings supported by JDK1.x.
Character Encoding Explanation
8859_1 ISO Latin-1
8859_2 ISO Latin-2
8859_7 ISO Latin/Greek
Cp1257 Windows Baltic
Cp1258 Windows Vietnamese
Cp437 PC Original
EUCJIS Japanese EUC
GB2312 GB2312-80 Simplified Chinese
JIS JIS
KSC5601 KSC5601 Korean
MacCroatian Macintosh Croatian
MacCyrillic Macintosh Cyrillic
SJIS PC and Windows Japanese
UTF-8 Standard UTF-8

Examples of specifying the codeset in import and export procedures

The following example shows how to specify UTF-8 encoding to export to the staff.dat table:
CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE
    (NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8')
The following example shows how to specify UTF-8 encoding to import from the staff.dat table:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
    (NULL,'STAFF','staff.dat',NULL,NULL,'UTF-8',0)
 

javadb@jdbcurl.com