Re: [GENERAL] retry: converting ASCII to UTF-8

2008-01-24 Thread Albe Laurenz
Tom Hart wrote: > Originally I set up the database to use ASCII encoding. However we > have a large base of Spanish speaking members and services, > and we need utf-8 encoding to maintain and support the extended character > sets. In my naivety I thought it would be a relatively simple process > t

[Fwd: Re: [GENERAL] retry: converting ASCII to UTF-8]

2008-01-23 Thread Tom Hart
Martin Gainty wrote: character encoding is implemented at Database level not the table http://www.postgresql.org/docs/8.2/interactive/sql-createdatabase.html CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ]