pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 //



view thread (27+ messages)  latest in thread

Message-ID: <444E4859.7090103@magproductions.nl>
Permalink:  ../444E4859.7090103@magproductions.nl/
Also on:    postgresql.org/message-id/444E4859.7090103@magproductions.nl

 · 

reply

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