On Wed, Apr 05, 2006 at 10:15:18PM +0200, Harald Fuchs wrote: > In article <20060405135419.GD18401@xxxxxxxxx>, > Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > > > As a british user, latin9 will cover most of your needs, unless > > ofcourse someone wants to enter their name in chinese :) > > Since british users don't use French OE ligatures or Euro currency > signs, even latin1 would do. However as a British PostgreSQL user, I would really like to encourage the O.P. to use UNICODE for _every_ database. My question: Is it possible to upgrade a database from ASCII to UNICODE without dumping and restoring? Rich. -- Richard Jones, CTO Merjis Ltd. Merjis - web marketing and technology - http://merjis.com Team Notepad - intranets and extranets for business - http://team-notepad.com