Skip site navigation (1) Skip section navigation (2)

Re: Database encoding

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 (view raw or flat)
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


In response to

pgsql-it-generale by date

Next:From: gabriele.bartoliniDate: 2010-10-05 19:54:21
Subject: Aggiornamenti di sicurezza e ... addio PostgreSQL 7.4 e 8.0!
Previous:From: Stefan MutschlechnerDate: 2010-03-26 17:15:39
Subject: Database encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group