pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLatin-2 sort order
3+ messages / 2 participants
[nested] [flat]
* Latin-2 sort order
@ 2001-08-30 00:16 Michał Pasternak <doc@lublin.t1.pl>
0 siblings, 1 reply; 3+ messages in thread
From: Michał Pasternak @ 2001-08-30 00:16 UTC (permalink / raw)
To: pgsql-sql
Hello,
since a few hours I try to set-up Latin-2 sort order in PostgreSQL 7.1.3. I
have re-compiled it with MB and Latin2, I have re-initialized database, I
have restored dumps, which contained "ENCODING='LATIN2'" in it ... and it's
still nothing.
Could anyone send me a step-by-step instruction, or at least some URL?
Please, I know it's RTFM-type-question, but the time is against me.
I'm usint PGSQL on FreeBSD 4.3-STABLE.
--
[ Michal Pasternak doc@lublin.t1.pl +48606570000 ]
[ sklepy internetowe, bazy danych, programy na zamówienie ]
[ . .. ..- .- . .. http://lublin.t1.pl . .-. .--.. . . .- ]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latin-2 sort order
@ 2001-08-30 01:55 Tatsuo Ishii <t-ishii@sra.co.jp>
parent: Michał Pasternak <doc@lublin.t1.pl>
0 siblings, 1 reply; 3+ messages in thread
From: Tatsuo Ishii @ 2001-08-30 01:55 UTC (permalink / raw)
To: doc@lublin.t1.pl; +Cc: pgsql-sql
> since a few hours I try to set-up Latin-2 sort order in PostgreSQL 7.1.3. I
> have re-compiled it with MB and Latin2, I have re-initialized database, I
> have restored dumps, which contained "ENCODING='LATIN2'" in it ... and it's
> still nothing.
You need to enable locale support. MB support does nothing with the
sort order.
--
Tatsuo Ishii
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Latin-2 sort order
@ 2001-08-31 00:59 Tatsuo Ishii <t-ishii@sra.co.jp>
parent: Tatsuo Ishii <t-ishii@sra.co.jp>
0 siblings, 0 replies; 3+ messages in thread
From: Tatsuo Ishii @ 2001-08-31 00:59 UTC (permalink / raw)
To: doc@lublin.t1.pl; +Cc: pgsql-sql
> > You need to enable locale support. MB support does nothing with the
> > sort order.
>
> I guess You mean:
>
> ./configure --enable-locale
> export LANG=pl_PL
> run postmaster
Yes.
> and now should I
>
> initdb
>
> or just simply browse the database as usual?
I'm afraid you are forced initdb.
I think postmaster coming with PostgreSQL 7.1 or later won't start up
if locale is enabled and the specified locale is different from the
initdb time (if locale is not enabled in PostgreSQL, the current
locale would be assumed as C).
--
Tatsuo Ishii
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-08-31 00:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-30 00:16 Latin-2 sort order Michał Pasternak <doc@lublin.t1.pl>
2001-08-30 01:55 ` Tatsuo Ishii <t-ishii@sra.co.jp>
2001-08-31 00:59 ` Tatsuo Ishii <t-ishii@sra.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox