pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Changing 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