Re: Changing locale

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