Just a note on this.
> > 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. http://www.efficito.com/learn_more.shtml