...
| Panel |
|---|
#3.1 Delete the database. $ server stop $ cd $ALTIBASE_HOME $ rm dbs/* $ rm logs/*
#3.2 Create a DB with a new character set. $ export ALTIBASE_NLS_USE=MS949 $ server create MS949 UTF16
#3.3 Check the DB character set. iSQL> set vertical on; iSQL> select * from v$nls_parameters; SESSION_ID : 1 NLS_USE : MS949 NLS_CHARACTERSET : MS949 NLS_NCHAR_CHARACTERSET : UTF16 NLS_COMP : BINARY NLS_NCHAR_CONV_EXCP : FALSE NLS_NCHAR_LITERAL_REPLACE : FALSE |
STEP 4: Use the schema information downloaded from STEP1 to configure the schema in the newly created DB.
| Panel |
|---|
#4.1 Execute the schema creation shell script created by aexport and check whether the schema has been successfully created. $ sh run_is.sh iSQL> select * from tab; |
STEP 5: Use the data import tool to upload the data downloaded in STEP2 using the changed character set. Example) UTF8
| Panel |
|---|
#5.1 Change the NLS_USE setting in the form file created in STEP 2.2 to a new character set. $ export ALTIBASE_NLS_USE=MS949 $ cat *.fmt table HANGUL_T { "C1" char (500); } DATA_NLS_USE=MS949 #5.2 Execute a shell script that imports the data created by aexport and upload the data to the table. $ sh run_il_in.sh
#5.3 Check the table containing Korean characters to see if the data has been uploaded normally. iSQL> select * from v$nls_parameters; SESSION_ID : 1 NLS_USE : MS949 NLS_CHARACTERSET : MS949 NLS_NCHAR_CHARACTERSET : UTF16 NLS_COMP : BINARY NLS_NCHAR_CONV_EXCP : FALSE NLS_NCHAR_LITERAL_REPLACE : FALSE
iSQL> select * from hangul_t; C1 : US7ASI Hangul test |