To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51965
Issue #:|51965
Summary:|Error inserting numeric data into PostgreSQL using
|JDBC
Component:|Database access
Version:|OOo 2.0 Beta
Platform:|PC
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|johnix
------- Additional comments from [EMAIL PROTECTED] Thu Jul 14 06:24:34 -0700
2005 -------
I am unable to insert some data fields when using PostgreSQL 8.0 with
postgresql-8.0-311.jdbc3.
Trying to update or insert a numeric(8,2) field pops up an error box saying
"ERREUR : la colonne montant est de type numeric mais l'expression est de type
character varying", which translates to "ERROR : the column is of type numeric,
but the expression is of type character varying".
I reproduced the bug on Linux/x86 and Windows XP. It does not appear if I
replace the JDBC driver with the SDBC or ODBC driver, on either OS.
The locale for my database server is French (France), whose punctuation symbol
is a comma. The bug can be reproduced whether I check or uncheck the 'separator
key same as local setting" option in Options->tools->Language
settings->Languages, and whether I set the "locale setting" to one using "," or
".".
The same message pops up whether I enter the value "300", "3,3" or "3.3". The
data displays as "300,00" no matter how I set the above mentionned parameters.
I was unable to reproduce the exact same error message when using psql to type
SQL commands directly into the database backend. Here is an illustration :
p140=# insert into type_personnel values ('plop', '12,3');
ERREUR: Syntaxe en entrée invalide pour le type numeric : «12,3»
p140=# insert into type_personnel values ('plop', 12.3);
INSERT 21757 1
p140=# insert into type_personnel values ('plopa', '12.4');
INSERT 21758 1
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
