> 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)
|