Just a note on this.
Don't add to template0. I think this would mess up backups.
Yes, I would drop the "template0" call and I think UTF8 is default now anyway.
Or maybe add them to template0 but that would be unusual I think
Don't add to template0. I think this would mess up backups.
As for whether UTF-8 is the default, it is in many cases, but I remember struggling with the fact that a few Linux distros still default to SQL-ASCII. Ultimately this is something of a packaging issue and the default may be set at the package level.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
