X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C17B011F6238 for ; Tue, 25 Apr 2006 13:04:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 43012-03 for ; Tue, 25 Apr 2006 13:03:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.magproductions.nl (magfour.magproductions.nl [87.249.97.162]) by postgresql.org (Postfix) with ESMTP id AD29C11F6089 for ; Tue, 25 Apr 2006 13:03:41 -0300 (ADT) Received: from cc756500-a.ensch1.ov.home.nl ([82.75.196.246] helo=[172.27.1.3]) by mx1.magproductions.nl with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1FYPy0-0004uJ-2q; Tue, 25 Apr 2006 18:00:44 +0200 Message-ID: <444E4859.7090103@magproductions.nl> Date: Tue, 25 Apr 2006 18:03:37 +0200 From: Alban Hertroys User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051010) X-Accept-Language: en-us, en MIME-Version: 1.0 To: IvoD CC: pgsql-general@postgresql.org Subject: Re: Database Selection References: <1145863743.280424.116910@y43g2000cwc.googlegroups.com> <1145946406.876724.302030@g10g2000cwb.googlegroups.com> In-Reply-To: <1145946406.876724.302030@g10g2000cwb.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/1107 X-Sequence-Number: 94548 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 //