Hi,
We upgraded the Windows ADC V8.1 to fixpack 5 on some Windows 2000
(Dutch Version) professional machines and something strange happened.
When we select decimal columns in our queries the decimal separator of
the decimal columns has become a comma while it was a dot.
Example resultset :
Before Fixpack 5:
40000.00
2030.00
304.23
After Fixpack 5:
40000,00
2030,00
304,23
Fixpack 5 is the first Fixpack we applied. We also saw the difference
using Quest Central. When we browsed some tables on a machine with
fixpack5 installed we saw the commas while on other machines without any
fixpacks we saw the dots.
Some interesting points to know:
* Our linux server (redhat 8.0 x86) was upgraded successfully to fixpack 5
* Our linux clients (slackware 9.0) were also upgraded successfully to
fixpack 5 and did not have the problem
* We have experimented with Country settings on Windows with rebooting
the machines but without changes in the resultsets
Well any advice would be very welcome.
Regards,
John Wheeler 1 2411
Today, I unstalled Fixpack 5 for 8.1 (FP5_WR21334_AD CL.exe) and instead
installed GA_ADCL.exe and I got the dot back in the decimal columns.
So we can continue our development. I've not a clue what the problem can be.
John Wheeler
John Wheeler wrote: Hi,
We upgraded the Windows ADC V8.1 to fixpack 5 on some Windows 2000 (Dutch Version) professional machines and something strange happened. When we select decimal columns in our queries the decimal separator of the decimal columns has become a comma while it was a dot.
Example resultset :
Before Fixpack 5:
40000.00 2030.00 304.23
After Fixpack 5:
40000,00 2030,00 304,23
Fixpack 5 is the first Fixpack we applied. We also saw the difference using Quest Central. When we browsed some tables on a machine with fixpack5 installed we saw the commas while on other machines without any fixpacks we saw the dots.
Some interesting points to know:
* Our linux server (redhat 8.0 x86) was upgraded successfully to fixpack 5 * Our linux clients (slackware 9.0) were also upgraded successfully to fixpack 5 and did not have the problem
* We have experimented with Country settings on Windows with rebooting the machines but without changes in the resultsets
Well any advice would be very welcome.
Regards,
John Wheeler
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mihajlo Canic |
last post by:
I have a very strange problem. Im working with MS Access db and oledb objects
(oledbadapter, oledbcommand, oledbconnection). Im using local cultureinfo
with "," as decimal separator, which is also set in regional settings of
machine. I have generated typed dataset based on one table with some decimal
fields. Everything works fine until I try to update database decimal column
with value from field, when my decimal comma is ignored (in db is...
|
by: John Bowman |
last post by:
Hi,
A couple Q's , so I've come to the experts<g>.
1) I need a definitive answer to the following debate. I've got a couple
developers who disagree on the following question. We've got an XML file of
numerical data results where it could contain values such as:
<RESULT>0.12345</RESULT> when created in English, but it could contain:
<RESULT>0,12345</RESULT> when created in another language... such as German
or French. One developer...
|
by: T.K Kullervo |
last post by:
Hi, is there someway to change the regional settings--> numbers--> decimal
separator for the the program im creating. I dont want to change it
permanently but my program doesnt work if the separator is a comma.
|
by: Chris Paul |
last post by:
I'm having trouble with PHP & PostgreSQL/OpenLDAP/Apache on Windows.
I've set this up countless times on BSD (piece of cake) but I'm trying
to do this on Windows now so that my developer can work on her local
machine.
Everything looks pretty good. OpenLDAP/cygwin works great. PostgreSQL
works great. Apache runs. PHP runs.
But when I try to connect to my PostgreSQL server using PHPPgAdmin, I
|
by: FAQ server |
last post by:
-----------------------------------------------------------------------
FAQ Topic - How do I convert a Number into a String with exactly 2 decimal places?
-----------------------------------------------------------------------
When formatting money for example, to format 6.57634 to
6.58, 6.5 to 6.50, and 6 to 6.00?
Rounding of x.xx5 is uncertain, as such numbers are not
represented exactly.
| |
by: apattin |
last post by:
Hi all,
I have a table containing MEASURE DOUBLE. I want to
SELECT measure FROM mytable WHERE <condition>
If measure = 1860.45, I get: '1,860.45'. How can I strip the comma? I
tried:
DECIMAL(measure,20,5) still has the comma
|
by: boder |
last post by:
I've set US locale with ',' (comma) as a decimal separator.
My code :
var xmlObject = new ActiveXObject("MSXML2.DOMDocument.3.0");
xmlObject.setProperty("SelectionLanguage", "XPath");
var datasetNode = xmlObject.createElement("dataset");
datasetNode.setAttribute("name", "test");
var recordNode = datasetNode.ownerDocument.createElement("test");
datasetNode.appendChild(recordNode);
recordNode.setAttribute("limit",5.5);
|
by: pozzobon |
last post by:
Hello
I live in Brazil and here we use comma (,) as decimal separator and period (.) as thousands separator.
How can I show my values in MySQL using the Brazilian way?
MySQL shows this: 123,456.00
I need it this way: 123.456,00
|
by: =?Utf-8?B?UGFvbG8=?= |
last post by:
I have a table column of SQL smallmoney type which I am updating via a form
input field defined as decimal.
If I enter, say, 51.09 via the decimal input field (representing $51.09),
this is
displayed as 5109.0000 when I view the table data.
I'm not sure why 4 decimal places are being shown, and how would I get the
table data to represent the input i.e. 51.09? I don't want to have to divide
by 10,000
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |