Thread: Changing locale

Changing locale

From
Ulrich Wisser
Date:
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

Re: Changing locale

From
Tom Lane
Date:
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