Re: A creepy story about dates. How to prevent it?

Tony Grant <tony@tgds.net>

From: Tony Grant <tony@tgds.net>
To: postgres list <pgsql-general@postgresql.org>
Date: 2003-06-24T16:52:43Z
Lists: pgsql-general
On Tue, 2003-06-24 at 18:01, Lincoln Yeoh wrote:

> 
> What if a European DB backed website is hosted on a US server with English, 
> French and German data?

Dates are no big deal. The front end can translate PostgreSQL format
dates to/from whatever format you want.

My big challenge (I am in the above case - UK server [rackspace] and
French data) is the decimal separator. I can't figure how to get a ","
as my decimal seperator. If I try modifying postgresql.conf the
postmaster refuses to start. I _don't_ want to write a fance procedure
into each and every JSP to work around this. And my client refuses to
use the "."...

Cheers

Tony Grant
-- 
www.tgds.net Library management software toolkit, 
redhat linux on Sony Vaio C1XD, 
Dreamweaver MX with Tomcat and PostgreSQL