On Fri, Aug 29, 2008 at 11:29:55PM +0800, Phoenix Kiula wrote: > So how can I change the locale on my local OSX machine? This could be > it. Thanks! Before you start restoring, put a LANG environment variable. So something like LANG=en_US.UTF-8 psql or else LANG=en_US.UTF-8; export LANG [other stuff] A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxxxx +1 503 667 4564 x104 http://www.commandprompt.com/