|
> select '바보바보' = '똥통휴지';
?column?
----------
t
(1 row)
ㅡ_-);;;
DATABASE를 생성할 때 EUC_KR로 생성하였습니다.
또한 initdb.18n 의 내용은 다음과 같습니다.
LANG="ko_KR.eucKR"
SUPPORTED="ko_KR.eucKR:ko_KR:ko"
SYSFONT="latarcyrheb-sun16"
export LANG LC_ALL LC_CTYPE LC_COLLATE LC_NUMERIC LC_CTYPE LC_TIME
postgresql.conf 의 Locale 설정은 다음과 같습니다.
LC_MESSAGES = 'ko_KR.eucKR'
LC_MONETARY = 'ko_KR.eucKR'
LC_NUMERIC = 'ko_KR.eucKR'
LC_TIME = 'ko_KR.eucKR'
Database 생성은 다음과 같이 하였습니다.
$ CREATE DATABASE mydb ENCODING='EUC_KR';
ㅡ_-) 인코딩 문제인 것 같은데...
아무리 봐도 '바보바보'와 '똥통휴지'는 같은게 아닌데,
자꾸 같다고 판단하더군요.
덕분에 unique 속성에 걸려서 레코드 삽입이 안 되는군요...
어떻게 해야하나요.
$ select version();
version
-------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)
$ pg_controldata
pg_control version number: 72
Catalog version number: 200211021
Database cluster state: in production
pg_control last modified:
Current log file ID: 0
Next log file segment: 1
Latest checkpoint location: 0/801A7C
Prior checkpoint location: 0/801A3C
Latest checkpoint's REDO location: 0/801A7C
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 17
Latest checkpoint's NextXID: 499
Latest checkpoint's NextOID: 16976
Time of latest checkpoint:
Database block size: 8192
Blocks per segment of large relation: 131072
Maximum length of identifiers: 64
Maximum number of function arguments: 32
Date/time type storage: Floating point
Maximum length of locale name: 128
LC_COLLATE: en_US.UTF-8
LC_CTYPE: en_US.UTF-8
$ show client_encoding;
client_encoding
-----------------
EUC_KR
(1 row)
$ show server_encoding;
server_encoding
-----------------
SQL_ASCII
(1 row)
|
