Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!feeder.erje.net!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Jens Riedel <JensRie@gmx.de>
Newsgroups: comp.lang.java.databases
Subject: Re: Problem with JDBC driver and MySQL date_format function
Date: Sun, 15 May 2011 21:17:42 +0200
Lines: 18
Message-ID: <93an6mFmd3U1@mid.individual.net>
References: <9340c7F40hU1@mid.individual.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net oj/6nZyMZbbJ863c1CEkigO7hKMJn0l2N7l5WAbGMOdiBsEcA9
Cancel-Lock: sha1:qRDDZTzvGZQz8grxJkgegT9KCiQ=
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
In-Reply-To: <9340c7F40hU1@mid.individual.net>
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:447

Thanks for your answers so far.
Meanwhile I found out that this seems to be an issue that's known and 
described here:

http://bugs.mysql.com/bug.php?id=32505

I checked it with DB Visualizer and I also get a BLOB there for "select 
date_format(now(), '%Y%m%d')", for example.

The problem is: as long as I work on my local Windows Mysql DB version 
5.0.67, everything is working fine; when I try on one of our both Linux 
MySQL 5.0.27 DBs I get this problem.
As it is a customer system an update to the same version would be much 
effort; what configuration settings should I check first to try to get 
rid of this problem for the Linux DBs?

Thanks for any ideas
Jens