Re: Problem with SUM and DECIMAL field

2005-02-24 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 LAFONTAINE Julien - LYO wrote: > Hi Mark, > > Thank you for your help. > > I have the same problem when I execute the query with the MySQL client on my > AIX server : > > mysql> select sum(AMFTPF) from DWH_AMF; > > +-+ > | sum(AMFTPF) |

RE: Problem with SUM and DECIMAL field

2005-02-24 Thread LAFONTAINE Julien - LYO
, but maybe I'm doing something wrong. Regards, Julien -Message d'origine- De : Mark Matthews [mailto:[EMAIL PROTECTED] Envoyé : lundi 21 février 2005 16:24 À : LAFONTAINE Julien - LYO Cc : mysql@lists.mysql.com Objet : Re: Problem with SUM and DECIMAL field -BEGIN PGP

Re: Problem with SUM and DECIMAL field

2005-02-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 LAFONTAINE Julien - LYO wrote: > Hi everyone, > > I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9. > > Now I have a problem when using the SUM operator on DECIMAL field. > > The value returned by the SUM operator when used with

Re: Problem with SUM and DECIMAL field

2005-02-21 Thread Gleb Paharenko
Hell. I think you should read comments at: http://bugs.mysql.com/bug.php?id=1388 They are related to the ODBC connector, but may be it will help you to solve problems with Connector/J. LAFONTAINE Julien - LYO <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I've recentely upgar

Problem with SUM and DECIMAL field

2005-02-17 Thread LAFONTAINE Julien - LYO
Hi everyone, I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9. Now I have a problem when using the SUM operator on DECIMAL field. The value returned by the SUM operator when used with DECIMAL field has a coma (,) as decimal separator while it used to be have a dot (.) . If I