By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,840 Members | 2,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,840 IT Pros & Developers. It's quick & easy.

korean encoding, sort order off anyhow

P: n/a
hi,
To see the query results in native language see

http://database.sarang.net/?inc=read...eyword=&page=1

the simpler url is

http://database.sarang.net/?criteria=pgsql

becase there is no korean postgresql list. poster is "joesp"

basically the characters are off when sorting. As for how the koreans are doing things, that's why I'm asking them on database.sarang.net. BTW is there another location to look for help in korea, if you are aware of one I would like to know it.

I am at a crossroads why after the following the sort order is off. I think I've followed all the advice from the manual, as well.
[postgres@www pgsql]$ initdb --locale=ko_KR --lc-messages=C -E unicode -D `pwd`/unidata

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales
COLLATE: ko_KR
CTYPE: ko_KR
MESSAGES: C
MONETARY: ko_KR
NUMERIC: ko_KR
TIME: ko_KR

creating directory /bup/pgsql/unidata ... ok
creating directory /bup/pgsql/unidata/global ... ok
creating directory /bup/pgsql/unidata/pg_xlog ... ok
creating directory /bup/pgsql/unidata/pg_clog ... ok
creating directory /bup/pgsql/unidata/base ... ok
creating directory /bup/pgsql/unidata/base/1 ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /bup/pgsql/unidata/base/1 ... ok
initializing pg_shadow ... ok
enabling unlimited row size for system tables ... ok
initializing pg_depend ... ok
creating system views ... ok
loading pg_description ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok

Success. You can now start the database server using:

/usr/local/pgsql/bin/postmaster -D /bup/pgsql/unidata
or
/usr/local/pgsql/bin/pg_ctl -D /bup/pgsql/unidata -l logfile start

[postgres@www pgsql]$
[postgres@www pgsql]$ pg_ctl -D /bup/pgsql/unidata/ -o "-p5433" start
postmaster starting
[postgres@www pgsql]$ LOG: database system was shut down at 2004-06-16 15:57:34 CDT
LOG: checkpoint record is at 0/9F60DC
LOG: redo record is at 0/9F60DC; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 490; next OID: 17207
LOG: database system is ready
[postgres@www pgsql]$
[postgres@www pgsql]$ psql -p 5543 -d template1
Welcome to psql 7.5devel, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# \dt
No relations found.
template1=#create database korean;
CREATE DATABASE
template1=\c korean
template1=\q
[postgres@www bup]$ psql -p 5543 -d korean < korean.sql
..... many insert statements, etc, as korean.sql is dump of other korean db
[postgres@www bup]$ psql -p 5543 -d korean
Welcome to psql 7.5devel, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

korean=#
korean=# \encoding utf8
korean=# select id,word from korean order by word;
id | word
----+----------
68 | 생성
72 | 두가지
67 | 설문
69 | 단순하게
66 | 강좌
73 | 깔다
65 | 막막
70 | 반면
71 | 지*
(9 rows)

korean=# \encoding unicode
korean=# select id,word from korean order by word;
id | word
----+----------
68 | 생성
72 | 두가지
67 | 설문
69 | 단순하게
66 | 강좌
73 | 깔다
65 | 막막
70 | 반면
71 | 지*
(9 rows)
(the order is incorrect and unsorted)
korean-# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
korean | postgres | UNICODE
template0 | postgres | UNICODE
template1 | postgres | UNICODE
(3 rows)

korean-#


--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.