Cory Nemelka <cnemelka@xxxxxxxxx> writes: > Here is encoding for existing database: > List of databases > ┌───────────┬──────────┬──────────┬─────────────┬─────────────┬───────────────────────┐ > │ Name │ Owner │ Encoding │ Collate │ Ctype │ Access > privileges │ > ├───────────┼──────────┼──────────┼─────────────┼─────────────┼───────────────────────┤ > │ thedatabase │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ > │ Hmm. It's interesting that the collate/ctype locales say "UTF-8" where locale -a says "utf8". It's not apparent to me what relation that might have to your observed problem, but it suggests that this cluster doesn't exactly have a pristine history. Did you perhaps try to move the data files from one platform to another? regards, tom lane
