pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedChanging locale
2+ messages / 2 participants
[nested] [flat]
* Changing locale
@ 2005-12-21 10:45 Ulrich Wisser <liste@publisher.de>
2005-12-21 16:13 ` Re: Changing locale Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Ulrich Wisser @ 2005-12-21 10:45 UTC (permalink / raw)
To: pgsql-admin
Hello,
after Tom's last hint I checked the locale of my installation. With a
test installation with locale C all my problem scripts worked. Now I
wonder what will happen if I dump my whole database, reinitialize with
locale C and reload my data. Will this have some impact on my character
data even if I choose the same encoding (SQL_ASCII) as before?
Ulrich
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Changing locale
2005-12-21 10:45 Changing locale Ulrich Wisser <liste@publisher.de>
@ 2005-12-21 16:13 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-12-21 16:13 UTC (permalink / raw)
To: Ulrich Wisser <liste@publisher.de>; +Cc: pgsql-admin
Ulrich Wisser <liste@publisher.de> writes:
> after Tom's last hint I checked the locale of my installation. With a
> test installation with locale C all my problem scripts worked. Now I
> wonder what will happen if I dump my whole database, reinitialize with
> locale C and reload my data. Will this have some impact on my character
> data even if I choose the same encoding (SQL_ASCII) as before?
With locale C you can use any encoding you want; the impact will be that
sort order of text comparison is just by raw bytes, and upper/lower case
functions will only deal with plain ASCII A-Z/a-z.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-12-21 16:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-21 10:45 Changing locale Ulrich Wisser <liste@publisher.de>
2005-12-21 16:13 ` Tom Lane <tgl@sss.pgh.pa.us>
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