From: | gabriele(dot)bartolini(at)2ndquadrant(dot)it |
---|---|
To: | pgsql-it-generale(at)postgresql(dot)org |
Subject: | Re: Database encoding |
Date: | 2010-03-26 18:33:18 |
Message-ID: | 4BACFDEE.8010907@2ndQuadrant.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-it-generale |
Salve Stefan,
purtroppo non è possibile cambiare con un comando del tipo "ALTER
DATABASE" l'encoding di un database. Deve per forza di cose esportare e
reimportare i dati.
A presto,
Gabriele
Stefan Mutschlechner ha scritto:
>
>
>
>
>
>
>
>
> Il mio database ha win1252 come encoding.
>
>
>
> -- Database: utsdb
>
>
>
> -- DROP DATABASE utsdb;
>
>
>
> CREATE DATABASE utsdb
>
> WITH OWNER = postgres
>
> ENCODING = 'WIN1252';
>
>
>
>
>
> Come faccio a metterlo su UTF8 senza recrearlo???
>
>
>
>
>
> P. Elet. Ind. Stefan Mutschlechner
>
> Chief of control engineering department
>
> T +39 340 71 51 857
>
> E s(dot)mutschlechner(at)ts-energygroup(dot)com
> <mailto:s(dot)mutschlechner(at)ts-energygroup(dot)com>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *P. Elet. Ind. Stefan Mutschlechner*
> Chief of control engineering department
> T +39 340 71 51 857* **
> *E s(dot)mutschlechner(at)ts-energygroup(dot)com
> <mailto:s(dot)mutschlechner(at)ts-energygroup(dot)com>* *
>
>
>
>
>
> *B.T.S. ITALIA* srl/GmbH
> Via S. Lorenzo, 34 St. Lorenznerstrasse
> I-39031 Brunico/Bruneck (BZ)
>
> T +39 0474 37 01 19
> F +39 0474 55 28 36
> P.IVA: 02590590218
>
> I www.ts-energygroup.com <http://www.ts-energygroup.com>*
> **
>
> *****
>
>
>
>
>
>
>
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
From | Date | Subject | |
---|---|---|---|
Next Message | gabriele.bartolini | 2010-10-05 19:54:21 | Aggiornamenti di sicurezza e ... addio PostgreSQL 7.4 e 8.0! |
Previous Message | Stefan Mutschlechner | 2010-03-26 17:15:39 | Database encoding |