<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. </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: 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"> 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>