칼럼내에 한글이 포함된 항목은 오류가 발생합니다.
아무래도 characterset에 관련된 문제로 보이는데..
* oracle characterset
NAME VALUE COMMENT
NLS_CHARACTERSET KO16MSWIN949 Character set
NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set
* postgresql
show server_encoding; >> UTF8
show client_encoding; >> UTF8
현재 설정입니다.
sqline이라는 툴을 사용중인데...에러메세지도 깨져서 나오는데요
SQLines Data 3.3.13 x64 - Database Migration Tool.
Copyright (c) 2019 SQLines. All Rights Reserved.
Connecting to databases (109 ms)
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production (Ok, 47 ms)
PostgreSQL 11.5, compiled by Visual C++ build 1914, 64-bit (Ok, 109 ms)
Reading the database schema (1 table, 204 ms)
Transferring database (1 session):
SYSTEM.AUTHMENU_20140306 - Started (1 of 1, session 1)
SYSTEM.AUTHMENU_20140306 - Open cursor (172 rows read, 0 ms, session 1)
SYSTEM.AUTHMENU_20140306 - Data transfer failed
ì¤ë¥: "UTF8" ì¸ì½ë©ìì ì¬ì©í ì ìë 문ìê° ìì: 0xc1 0xa1
CONTEXT: authmenu_20140306 ë³µì¬, 1ë²ì§¸ ì¤
Rows read: 172 (0 rows/sec)
Rows written: 172 (0 rows/sec, 18.4 KB, 0 bytes/sec)
Transfer time: 15 ms (0 ms read, 0 ms write)
Failed tables (1 table):
characterset을 어떻게 변경해야 좋을지 문의드립니다.
감사합니다.
|