'[postgis-users] Changing regional setting for a numeric field in a single database'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Changing regional setting for a numeric field in a single database
From:       Robert Buckley <robertdbuckley () yahoo ! com>
Date:       2012-06-28 12:07:20
Message-ID: 1340885240.99283.YahooMailNeo () web133005 ! mail ! ir2 ! yahoo ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Hi,

on trying to import data from csv I am now having a problem with regional settings. 

At the moment it looks like this;

db=#show client_encoding;

UTF8

db=#show lc_numeric;

de_DE.utf8

The problem is that I have getting this error;

ERROR:  invalid input syntax for type numeric: "2.000,000"

I have defined this field as...

 numeric(11,4)

and thus the problem is that the decimal and thousand separators are mixed up.

Would anyone know how I can set this properly to this one database?

Thanks for any help,

Rob
[Attachment #5 (text/html)]

<html><body><div style="color:#000; background-color:#fff; font-family:arial, \
helvetica, sans-serif;font-size:10pt"><div style="font-family: arial, helvetica, \
sans-serif; font-size: 10pt; ">Hi,</div><div style="font-family: arial, helvetica, \
sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, \
sans-serif; font-size: 10pt; ">on trying to import data from csv I am now having a \
problem with regional settings.&nbsp;</div><div style="font-family: arial, helvetica, \
sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, \
sans-serif; font-size: 10pt; ">At the moment it looks like this;</div><div \
style="font-family: arial, helvetica, sans-serif; font-size: 10pt; \
"><br></div><div><font size="2">db=#show client_encoding;</font><br></div><div><font \
size="2">UTF8<br></font></div><div><font size="2"><br></font></div><div><font \
size="2">db=#show lc_numeric;<br></font></div><div><font  \
size="2">de_DE.utf8<br></font></div><div><font size="2"><br></font></div><div><font \
size="2">The problem is that I have getting this error;</font></div><div><font \
size="2"><br></font></div><div><font size="2">ERROR: &nbsp;invalid input syntax for \
type numeric: "2.000,000"<br></font></div><div><font \
size="2"><br></font></div><div><font size="2">I have defined this field \
as...</font></div><div><font size="2"><br></font></div><div><font \
size="2">&nbsp;numeric(11,4)</font></div><div><font \
size="2"><br></font></div><div><font size="2">and thus the problem is that the \
decimal and thousand separators are mixed up.</font></div><div><font \
size="2"><br></font></div><div><font size="2">Would anyone know how I can set this \
properly to this one database?</font></div><div><font \
size="2"><br></font></div><div><font size="2"><br></font></div><div><font \
size="2">Thanks for any help,</font></div><div><font \
size="2"><br></font></div><div><font size="2">Rob</font></div>   </div></body></html>

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 