Content-class: urn:content-classes:message
Subject: Are SQL queries locale dependent?
Date: Fri, 25 Feb 2005 09:41:03 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-ID: <AA31868BC8CE1B4DB132141A6556A20A8D90@dev010_ex.Dev.cadcorp.net>
Thread-Topic: Are SQL queries locale dependent?
Thread-Index: AcUbHh9gESt4kN15TDuLsKnFciqeCQ==
From: =?iso-8859-1?Q?Martin_Sch=E4fer?= <Martin.Schaefer@cadcorp.com>
To: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>

Hi,

I recently found out that my app doesn't work in Spain because it =
creates localized queries like this:

create table t (c1 float8, c2 float8);
insert into t (c1, c2) values (3,14159, 1,4142);

I understand that PostgreSQL obviously can't parse this query. But I'm =
not sure how to fix this query so that it works under all circumstances.

If the database uses the "C" (or e.g. English or US) locale, then I know =
that I always have to use the decimal dot ('.') instead of a decimal =
comma (','), regardless of the locale of the client machine.

But what if the database itself uses a locale which mandates a decimal =
comma, like Spanish, German, etc.? How do I have to construct the SQL =
query then?

Martin