From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | 本家pgsql-hackersについて日本語で議論するML <hackers-jp(at)ml(dot)postgresql(dot)jp>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [hackers-jp: 219] Re: postgresql-8.1.4文字セットサポート |
Date: | 2006-07-28 04:49:46 |
Message-ID: | A2EA253B-6AAF-42C3-840B-8A1D72AA9D83@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Jul 28, 2006, at 12:37 , ISHIDA Akio wrote:
> | SJIS サーバの符号化方式としてはサポートしていません。
Just to confirm, it does look like there's a discrepancy between what
is in the documentation and the actual behavior of the server. The
documentation indicates that SJIS is a valid server encoding:
http://www.postgresql.org/docs/current/interactive/
multibyte.html#MULTIBYTE-CHARSET-SUPPORTED
I just tried to create a database with SJIS encoding using the
various aliases listed and was unable to do so:
grzm$ createdb shift_jis --encoding SJIS
createdb: database creation failed: ERROR: SJIS is not a valid
encoding name
grzm$ createdb shift_jis --encoding SHIFT_JIS
createdb: database creation failed: ERROR: SHIFT_JIS is not a valid
encoding name
grzm$ createdb shift_jis --encoding Mskanji
createdb: database creation failed: ERROR: Mskanji is not a valid
encoding name
grzm$ createdb shift_jis --encoding WIN932
createdb: database creation failed: ERROR: WIN932 is not a valid
encoding name
grzm$ createdb shift_jis --encoding Windows932
createdb: database creation failed: ERROR: Windows932 is not a valid
encoding name
grzm$ psql postgres
Welcome to psql 8.1.4, 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
postgres=# select version();
version
------------------------------------------------------------------------
----------------------------------------------------------------------
PostgreSQL 8.1.4 on powerpc-apple-darwin8.6.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc.
build 5341)
(1 row)
postgres=# create database shift_jis with encoding 'SHIFT_JIS';
ERROR: SHIFT_JIS is not a valid encoding name
postgres=# create database shift_jis with encoding 'SJIS';
ERROR: SJIS is not a valid encoding name
Michael Glaesemann
grzm seespotcode net
From | Date | Subject | |
---|---|---|---|
Next Message | satoshi nagayasu | 2006-07-28 06:00:18 | Re: pgstattuple extension for indexes |
Previous Message | Alvaro Herrera | 2006-07-28 04:05:22 | Re: The vacuum-ignore-vacuum patch |