From: Alban Hertroys <alban@magproductions.nl>
To: IvoD <gordion@quick.cz>
Cc: pgsql-general@postgresql.org
Subject: Re: Database Selection
Date: Tue, 25 Apr 2006 18:03:37 +0200
Message-ID: <444E4859.7090103@magproductions.nl> (raw)
In-Reply-To: <1145946406.876724.302030@g10g2000cwb.googlegroups.com>
References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com>
<BAY101-DAV104E25204EDB4E872DA29FA3BE0@phx.gbl>
<1145946406.876724.302030@g10g2000cwb.googlegroups.com>
IvoD wrote:
> real experience and real enterprise applications. And last but not
> least - I must run db engine on Win platform (not Linux) and all the
> "success stories" assume Linux platform. So does somebody here know
Well, for one thing... I have some experience with MySQL in that
respect, and I know that migrating MySQL on Windows to MySQL on Linux
(or a UNIX) causes trouble.
MySQL stores its' tables as files on the file system, which is case
insensitive on Windows and case sensitive on UNIX. If you didn't take a
lot of care to use the same case in your queries and your table
definitions, your queries will stop working once you migrate to UNIX...
With respect to PostgreSQL on Windows, utf-8 encoding isn't natively
supported on that platform, so you better don't use that for your
database encodings. A fix is in the works, if I understand correctly,
but AFAIK it isn't there yet.
Mind though that I rarely use Windows; I use it almost exclusively for
playing games. I am biased ;)
--
Alban Hertroys
alban@magproductions.nl
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: alban@magproductions.nl, gordion@quick.cz
Subject: Re: Database Selection
In-Reply-To: <444E4859.7090103@magproductions.nl>
References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com> <BAY101-DAV104E25204EDB4E872DA29FA3BE0@phx.gbl> <1145946406.876724.302030@g10g2000cwb.googlegroups.com> <444E4859.7090103@magproductions.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox