Client Configuration

[Didier]

Hello,

I am connecting to PostgreSQL using the components from SQL-DIRECT which I have used with great success on other databases (Sybase, Firebird, SqlServer ....). When I connect in ODBC mode then everything works fine, when I connect directly to the pgsql drivers, I lack some configuration capabilities and I am trying to find the SET ... command equivalent but after several hours of searching I am getting nowhere; hence my question here.

My main issue is that I am using a French Windows XP, which international configuration has been altered. Normal French decimal separator is comma and thousands separator is space (e.g. 10000 is written 10 000,00). For loads of reason, I always reconfigure it to be like the UK config :
full-stop as decimal separator and comma as thousands separator. (e.g. 10000 is written 10,000.00). In this altered configuration, I get an error message when reading floating points numbers. For example the database value is 75 the error message is error converting '75 00' to a floating point value.

How can I set the decimal separator to use on my connection ?

Please note that I am very new to PostgreSQL so please forgive me if the question is really stupid, but I am very stuck with this.

Didier

[Support Administrator]

Hi,
I think you would need to set the following for your locale:

lc_monetary = 'en_US.UTF-8'         # locale for monetary formatting
lc_numeric = 'en_US.UTF-8                        # locale for number formatting

Be sure to read Client Connection Defaults here:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-client.html

That should get you going.

Hope that helps,

Tony

[didiergm]

It did, thanks

Didier