To Miguel: It also displays the floats for me but with all decimal parts
changed into 0000 for example 20.76 will show up as 20,00 (This happens even
if the entire computer settings are not set to French; me I use an English
computer but for some testing, I just set numbers to French and this
happens)

Just check again to make sure that it will show NON-zero decimal parts (I
mean can you see a number like 18,3455 ?
I worked with this application for 6 months without realizing that non-zeros
were changed into zeros.

Thanks
Emery

----- Original Message -----
From: "Bug Database" <dev-bugs [at] mysql.com>
To: <dg [at] nefacomp.net>
Sent: Friday, October 03, 2003 05:11
Subject: Bug #1388 [Opn->!Bg]: MyODBC ignores decimals of a float for client
using comma as decimal separator


> ATTENTION! Do NOT reply to this email!
> To reply, use the web interface found at
> http://bugs.mysql.com/?id=1388&edit=2
>
>
> ID: 1388
> Updated by: Miguel Solorzano
> Reported by: name withheld
> User Type: User
> Originating List: General
> -Status: Open
> +Status: Not a Bug
> Severity: Serious
> Priority: Medium
> Category: Connector/ODBC
> Operating System: Windows
> Version: 3.51.06
> Assigned To: venu [at] mysql.com
> New Comment:
>
> I tested MyODBC on Windows XP Portuguese version which uses also the
>
> comma (,) as a decimal separator.
>
> I built a small graphical application with Borland Builder C++ and
>
> the float numbers were showed correctly with the comma decimal
>
> separator.
>
> Then I assume that your applicaction for unknown reason isn't handling
>
> the display of these type of data. Please contact the support of VB
>
> regarding this issue.
>
>
>
>
> Previous Comments:
> ------------------------------------------------------------ ------------
>
> [2003-09-24 01:28:59] name withheld
>
> Description:
> The application is VB using MyODBC to connect to the MySQL server.
>
> When the client machine uses English settings (for numbers), everything
> is OK but when the same application is used on a machine using
> non-english numbers (Like French), the decimal part of the number is
> removed before its presented to the application. French settings use a
> comma (,) as a decimal separator. So, the ODBC driver takes a number
> with a DOT to be a mixture of strings and digits and removes the digits
> after the string (. in this case).
> How to repeat:
> Install MyODBC on a Windows machine.
>
> Go to the regional settings of your client machine.
>
> Set the settings to use a comma as a decimal separator as done in the
> French system (for example 3,45). Or simply instruct your computer to
> use French settings for numbers.
>
> Run a query that should return FLOAT numbers from the MySQL server
> (stored as 3.54 on the server). The number comes correctly from the
> server but gets converted into 3.00 before entering the Visual Basic
> Application.
>
>
>
> When you run an Update query a number like 2,35 arrives into the server
> as 2.00 But a number like 2.35 arrives on the server correctly (as
> 2.35)
> Suggested fix:
> Have MyODBC convert numbers that pass through it. When a number like
> 3.56 comes from the server, MyODBC should convert it considering the
> locale settings on the client.
>
>
>
> Also another method is to convert the float into a string before coming
> from the server. I used this and it worked but with a DOT.
>
> ------------------------------------------------------------ ------------
>
>
>
>



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

--=======44B61930=======
Content-Type: text/plain; x-avg-checked=avg-ok-61BB7C44; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

At 11:43 3/10/2003 +0200, Director General: NEFACOMP wrote:
Hi,

>To Miguel: It also displays the floats for me but with all decimal parts
>changed into 0000 for example 20.76 will show up as 20,00 (This happens=
even
>if the entire computer settings are not set to French; me I use an English
>computer but for some testing, I just set numbers to French and this
>happens)
>
>Just check again to make sure that it will show NON-zero decimal parts (I
>mean can you see a number like 18,3455 ?

Yes. Please see the figure I sent you in separate e-mail.

>I worked with this application for 6 months without realizing that=
non-zeros
>were changed into zeros.

--
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano <miguel [at] mysql.com>
S=E3o Paulo - Brazil

--=======44B61930=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-61BB7C44
Content-Disposition: inline


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/9/2003


--=======44B61930=======
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
--=======44B61930=======--

On Fri, Oct 03, 2003 at 10:48:26AM -0300, miguel solorzano wrote:
> At 11:43 3/10/2003 +0200, Director General: NEFACOMP wrote:
> Hi,

Hi !!

Please dont send any bug reports mails to myodbc [at] list, instead edit the
report the directly using the browser.

>
> >To Miguel: It also displays the floats for me but with all decimal parts
> >changed into 0000 for example 20.76 will show up as 20,00 (This happens
> >even
> >if the entire computer settings are not set to French; me I use an English
> >computer but for some testing, I just set numbers to French and this
> >happens)
> >
> >Just check again to make sure that it will show NON-zero decimal parts (I
> >mean can you see a number like 18,3455 ?
>
> Yes. Please see the figure I sent you in separate e-mail.
>
> >I worked with this application for 6 months without realizing that
> >non-zeros
> >were changed into zeros.
>
> --
> Regards,
>
> For technical support contracts, visit https://order.mysql.com/
> Are you MySQL certified?, http://www.mysql.com/certification/
>
> Miguel Angel Solórzano <miguel [at] mysql.com>
> São Paulo - Brazil

>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.521 / Virus Database: 319 - Release Date: 23/9/2003
>

> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=venu [at] mysql.com

--

Venu, Software Developer
Palo Alto, CA, USA
MySQL Inc, http://www.mysql.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

>
> Please dont send any bug reports mails to myodbc [at] list, instead edit the
> report the directly using the browser.

Browser? Here I was just referred to this list :/

>
> >
> > >To Miguel: It also displays the floats for me but with all decimal
parts
> > >changed into 0000 for example 20.76 will show up as 20,00 (This happens
> > >even
> > >if the entire computer settings are not set to French; me I use an
English
> > >computer but for some testing, I just set numbers to French and this
> > >happens)
> > >
> > >Just check again to make sure that it will show NON-zero decimal parts
(I
> > >mean can you see a number like 18,3455 ?
> >
> > Yes. Please see the figure I sent you in separate e-mail.
> >
> > >I worked with this application for 6 months without realizing that
> > >non-zeros
> > >were changed into zeros.
> >
> > --
> > Regards,
> >
> > For technical support contracts, visit https://order.mysql.com/
> > Are you MySQL certified?, http://www.mysql.com/certification/
> >
> > Miguel Angel Solórzano <miguel [at] mysql.com>
> > São Paulo - Brazil
>
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.521 / Virus Database: 319 - Release Date: 23/9/2003
> >
>
> > --
> > MySQL ODBC Mailing List
> > For list archives: http://lists.mysql.com/myodbc
> > To unsubscribe: http://lists.mysql.com/myodbc?unsub=venu [at] mysql.com
>
> --
>
> Venu, Software Developer
> Palo Alto, CA, USA
> MySQL Inc, http://www.mysql.com
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=jim [at] fortunet.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org