From: "Joel Fradkin" <jfradkin@wazagua.com>
To: <pgsql-sql@postgresql.org>
Subject: 
Date: Mon, 7 Feb 2005 14:26:32 -0500
Message-ID: <000001c50d4a$f0eb4a60$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

In reading in the manual it seems the new database is based on =
template0.

I created my first database (wazagua) from the command line using =
dbcreate
wazagua.
It results in=20
CREATE DATABASE wazagua
  WITH OWNER =3D postgres
       ENCODING =3D 'SQL_ASCII';

When I created a test data base to load my backup I did this inside =
pgadmin
III and see it=20
CREATE DATABASE test
  WITH OWNER =3D postgres
       ENCODING =3D 'UNICODE';

So I think I see why when I try to restore I have issues.
My question is which is the correct choice?
We do have some chars that have French aschii, so is 'SQL_ASCII' or
'UNICODE' the correct choice?
I was able to move all my data over to the 'SQL_ASCII' database, so I =
may be
again answering my own question.
Values like d`Appr=E9hension show up ok in the table.

Am I guessing correctly to just make the database I am restoring to
'SQL_ASCII'?

I will try this.

Joel Fradkin
=A0
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.=A0 941-753-7111 ext 305
=A0
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,=A0Inc
=A0This email message is for the use of the intended recipient(s) and =
may
contain confidential and privileged information.=A0 Any unauthorized =
review,
use, disclosure or distribution is prohibited.=A0 If you are not the =
intended
recipient, please contact the sender by reply email and delete and =
destroy
all copies of the original message, including attachments.
=A0

=A0