Thread: encodings
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 stored in tables, or it influences database structure as well?
Thanks.
Zlatko
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 process? > In other words, does encoding influence only data stored in tables, or > it influences database structure as well? I can't think of how the encoding would influence the structure. Are you seeing behavior that suggests otherwise? -- Michael Fuhr
No, I didn't, I'm just courious. Regards, Zlatko ----- Original Message ----- From: "Michael Fuhr" <mike@fuhr.org> To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> 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 +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 process? >> In other words, does encoding influence only data stored in tables, or >> it influences database structure as well? > > I can't think of how the encoding would influence the structure. > Are you seeing behavior that suggests otherwise? > > -- > Michael Fuhr