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
CREATE DATABASE wazagua
WITH OWNER = postgres
ENCODING = 'SQL_ASCII';
When I created a test data base to load my backup I did this inside pgadmin
III and see it
CREATE DATABASE test
WITH OWNER = postgres
ENCODING = '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�hension 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
�
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.� 941-753-7111 ext 305
�
[EMAIL PROTECTED]
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
� 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA,�Inc
�This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.� Any unauthorized review,
use, disclosure or distribution is prohibited.� 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.
�
�
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
