Ulrich Wisser <liste@xxxxxxxxxxxx> 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
