Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 63C21474E50 for ; Thu, 1 Aug 2002 11:17:35 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id 0CA3438215C; Thu, 1 Aug 2002 11:16:59 -0400 (EDT) From: Jochem van Dieten X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Please Help me Date: Thu, 01 Aug 2002 17:16:48 +0200 Organization: OnLine Internet Lines: 24 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.tudelft.nl User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.1b) Gecko/20020721 X-Accept-Language: en-us, en To: pgsql-sql@postgresql.org X-Archive-Number: 200208/25 X-Sequence-Number: 8871 Michelle Murrain wrote: > > Yeah, except I do have experience with ColdFusion, and ColdFusion > runs into some very problematic issues with Postgres, sadly. Although > I use Postgres almost exclusively, I had to switch to MySQL for use > with ColdFusion. I wonder what your issues are, because in my experience it is very version related. With PostgreSQL versions before 7.1 there were various problems. As of 7.1, the main problem has been drivers. ColdFusion came with old (obsolete) drivers that didn't support many of the new features in postgreSQL. A custom compilation of new drivers was required, but was a tricky process. As of CF MX, IMHO PostgreSQL is the clear winner. For the very simple reason of full Unicode support, which means internationalization is a breeze. Simply save templates as UTF-8 and create a database with Unicode encoding and you are ready. And I am not aware of any problems with the JDBC drivers. Jochem PS Whichever you choose, use cfqueryparam exclusively in your queries.