Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 17C196502EE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 18 Nov 2008 14:19:28 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 32228-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 18 Nov 2008 14:19:24 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30])
	by mail.postgresql.org (Postfix) with ESMTP id A12C46502D2
	for <pgsql-admin@postgresql.org>; Tue, 18 Nov 2008 14:19:24 -0400 (AST)
Received: by yx-out-2324.google.com with SMTP id 8so1254444yxb.73
	for <pgsql-admin@postgresql.org>; Tue, 18 Nov 2008 10:19:23 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=fBJVV5MaL+N5ytyO9Eu+xO4nWsuwFyYldy29xfrSWNw=;
	b=GPn1x9x26the6Ty2XkTUTbhrkM0nn6TSKshVE3ZVL/fp7nR6Ndt0WSzK7FNHdtV/nf
	ejVo8xiOI+EfvHpau8zZv/MmxLUgOF0ITE1HNQuUCs1XJuvArTGeP3oRbJcBJ19g6kz8
	ioETLlXn4aka7SPvGgYp+AEOzvec1iCocyF/Q=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=aq3xwvX/rw3sPqVAXF8tdFcE1KdKAHK+8j4wf46J3Z79RUxTv6+FeRcH3/u8KKRffR
	9LbSfWVLL+acaKfVvN8qDQrn2HjWcTIXX8M6YoRgIPw4ZaDScjidbJvAYH5qC6QRAPQp
	hvxZQHwipy/Q1xQdi4an5WSz0fTodsBF5oH7A=
Received: by 10.151.100.17 with SMTP id c17mr414769ybm.64.1227032363733;
	Tue, 18 Nov 2008 10:19:23 -0800 (PST)
Received: by 10.151.115.16 with HTTP; Tue, 18 Nov 2008 10:19:23 -0800 (PST)
Message-ID: <c13f2d590811181019q5cb1a768ocf5780083efcaab3@mail.gmail.com>
Date: Tue, 18 Nov 2008 16:19:23 -0200
From: "Marcelo Costa" <marcelojscosta@gmail.com>
To: "Carol Walter" <walterc@indiana.edu>
Subject: Re: Changing encoding
Cc: pgsql-admin@postgresql.org
In-Reply-To: <30BF2B35-C7AC-4743-99FA-C98BFCD372B6@indiana.edu>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_67060_31764046.1227032363734"
References: <30BF2B35-C7AC-4743-99FA-C98BFCD372B6@indiana.edu>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/103
X-Sequence-Number: 30757

------=_Part_67060_31764046.1227032363734
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Carol

On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter <walterc@indiana.edu> wrote:

> Hello,
>
> I have some databases that are designated as "SQL_ASCII" encoding.  I need
> them to be "UTF-8".  I know that "SQL_ASCII" is really the absence of
> encoding.  Is there a way to do this?


Try use pg_dump on your ASCII database with option -E

ex.: pgdump -U user database -E UTF8 -f filename.sql


-- 
Marcelo Costa

------=_Part_67060_31764046.1227032363734
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Carol<br><br><div class="gmail_quote">On Tue, Nov 18, 2008 at 4:06 PM, Carol Walter <span dir="ltr">&lt;<a href="mailto:walterc@indiana.edu">walterc@indiana.edu</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
<br>
I have some databases that are designated as &quot;SQL_ASCII&quot; encoding. &nbsp;I need them to be &quot;UTF-8&quot;. &nbsp;I know that &quot;SQL_ASCII&quot; is really the absence of encoding. &nbsp;Is there a way to do this?</blockquote>
<div><br>Try use pg_dump on your ASCII database with option -E<br><br>ex.: pgdump -U user database -E UTF8 -f filename.sql<br><br></div></div><br>-- <br>Marcelo Costa<br><br>

------=_Part_67060_31764046.1227032363734--