Re: [GENERAL] encodings

2007-07-22 Thread Zlatko Matić
No, I didn't, I'm just courious. Regards, Zlatko - Original Message - From: Michael Fuhr [EMAIL PROTECTED] To: Zlatko Matić [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Sunday, July 22, 2007 5:41 AM Subject: Re: [GENERAL] encodings On Sat, Jul 21, 2007 at 10:24:38PM

[GENERAL] encodings

2007-07-21 Thread Zlatko Matić
Hello. If I have an UTF8 database, dump it and the restore as WIN1250 database, then dump it again and restore as UTF8, would structure of the database (schema) be exactly the same as initial database, or something will change in the process? In other words, does encoding influence only data

Re: [GENERAL] encodings

2007-07-21 Thread Michael Fuhr
On Sat, Jul 21, 2007 at 10:24:38PM +0200, Zlatko Matić wrote: If I have an UTF8 database, dump it and the restore as WIN1250 database, then dump it again and restore as UTF8, would structure of the database (schema) be exactly the same as initial database, or something will change in the

Re: [GENERAL] Encodings

2006-02-20 Thread Peter Eisentraut
Am Montag, 20. Februar 2006 08:55 schrieb Jan Cruz: When restoring a dump from sql_ascii encoding to latin9/utf8 This statement is both poorly specified and nonsensical. Please give us a more precise account of what you are doing. -- Peter Eisentraut http://developer.postgresql.org/~petere/

[GENERAL] Encodings

2006-02-19 Thread Jan Cruz
When restoring a dump from sql_ascii encoding to latin9/utf8 the THIS STRING| result to THIS STRINGŠ thus it aborted the restore. When I tried to dump a latin9/utf8 and restore it with the same encoding having same string it goes well but it took a very long time to copy all data. (1.6gb dump for