Install: Japanese: What options needed?

Started by Jean-Christian Imbeaultalmost 24 years ago2 messagesgeneral
Jump to latest
#1Jean-Christian Imbeault
jc@mega-bucks.co.jp

I am installing pgsql for the first time and I am a bit confused on some
of the compile options needed to enable Japanese language support (being
able to put japanese input into the DB and do operations on it. I have a
english Linux system and want to do admin stuff in english)

--enable-locale

I am assuming that I don't want this since I want to do admin stuff in
english. Am I right?

--enable-multibyte

I assume I need this and should preferably set it to EUC-JP? What is the
difference between this compile-time option and "initdb -E EUC_JP"?

Is doing "./configure --enable-multibyte=EUC_JP" all I need in order to
be able to put japanese into my DB and then do things like sorting?

Thanks!

Jc

#2Hiroki Takada
takada@rh.xdsl.ne.jp
In reply to: Jean-Christian Imbeault (#1)
Re: Install: Japanese: What options needed?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

of the compile options needed to enable Japanese language support (being
able to put japanese input into the DB and do operations on it. I have a
english Linux system and want to do admin stuff in english)

--enable-locale

I am assuming that I don't want this since I want to do admin stuff in
english. Am I right?

My Japanised linux box has been working well without this option for sorting
, seaching or other operations about tables that have Japanese text data,
however the manual descrive it affects sveral environments related programing
as well as admin stuffs.

http://www.postgresql.org/idocs/index.php?charset.html#LOCALE

--enable-multibyte

I assume I need this and should preferably set it to EUC-JP? What is the
difference between this compile-time option and "initdb -E EUC_JP"?

Is doing "./configure --enable-multibyte=EUC_JP" all I need in order to
be able to put japanese into my DB and then do things like sorting?

It makes using multiple-byte charactors in regular expressions, LIKE and
some other features possible as you may have know. please see the below
URL for detail.

http://www.postgresql.org/idocs/index.php?multibyte.html

I am not sure what you meant by 'sorting Japanese text'.
It works like a telephone directory as long as sorted data is all in
Hiragana or Katakana.

I hope it will work for you.

Hiroki

- --
----------------------------------------------------
Hiroki Takada <takada@rh.xdsl.ne.jp>

My public key is available at the public key
servers. The message was signed as iso-2022-jp
char-set document in no PGP/MINE (RFC 2015)
format.
----------------------------------------------------

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: KUHASIKU WA http://www.gnupg.org/ WO GORANKUDASAI

iD8DBQE9KFKnyTl8Jc+E3sERAu7GAJ97cQ//VlfFFDoWq6iyOssxsRme2QCgoRF3
+Da8b1wHmIv7YuTAqGEtZD0=
=COZN
-----END PGP SIGNATURE-----