International Informix Users Group

	Informix News

14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Development Tools Forum

Re: Decimal values without decimal separator?!

Posted By: Jonathan Leffler
Date: Thursday, 9 February 2006, at 1:27 a.m.

Summary: IDS versions that don't support GLS don't recognize
GLS-related environment variable settings.
> MESSAGE: (#61) Re: Decimal values without decimal separator?!
> AUTHOR: BENIAMINO SARNO
> DATE: Wednesday, 8 February 2006, at 1:24 p.m.
>
> I've got an exhaustive test.
> Here follows a brief report:
>
> SERVER ENVIRONMENT:
> Informix Dynamic Server ver. 07.12.0000 UC2
> Operative System Sco Open Server Release 5
IDS 7.12 has been obsolete for about a decade. You really, really,
really need to upgrade to something that is Y2K-compliant!
> DATABASE SCHEMA:
> Data columns:
> NUMSER: long integer
> PROGRE: long integer
> TORLAV: decimal(3,2)
>
> GLS ENVIRONMENT:
> All test permutations of DatabaseLocale, ClientLocale, ApplicationCulture with
> no SetNet32 (8 tests)
>
> All test permutations of DatabaseLocale, ClientLocale, ApplicationCulture with
> SetNet32 of dbmoney set to 'EURO',(8 tests)
>
> APPLICATION ENVIRONMENT:
> Operative System: WindowsXp Tablet PC Edition 2005 Version 2002 SP2 Build
> 5.1.2600 in English
>
> Informix Client SDK 2.90.TC3
This is more reasonable - much more reasonable.
> ..Net Framework version 1.1.4322.573
> MDAC 2.8 SP1
>
> TABLE OF DATA
> Test# Cli-Locale Db-Locale AppCul dbmoney stored updatng updated
> 1 en_US.8859-1 en_US.8859-1 en-US 643.25 574.40 574.4
> 2 en_US.8859-1 en_US.8859-1 it-IT 5744 188,57 18857
> 3 en_US.8859-1 it_IT.8859-1 en-US 188.57 722.82 722.82
> 4 en_US.8859-1 it_IT.8859-1 it-IT 72282 875,38 87538
> 5 it_IT.8859-1 en_US.8859-1 en-US 875.38 820.68 820.68
> 6 it_IT.8859-1 en_US.8859-1 it-IT 82068 677,32 67732
> 7 it_IT.8859-1 it_IT.8859-1 en-US 677.32 195.74 195.74
> 8 it_IT.8859-1 it_IT.8859-1 it-IT 19574 498,86 49886
>
> 1 en_US.8859-1 en_US.8859-1 en-US 'EURO', 49886 388.03 38803
> 2 en_US.8859-1 en_US.8859-1 it-IT 'EURO', 388,03 366,18 366,18
> 3 en_US.8859-1 it_IT.8859-1 en-US 'EURO', 36618 14.23 1423
> 4 en_US.8859-1 it_IT.8859-1 it-IT 'EURO', 14,23 971,66 971,66
> 5 it_IT.8859-1 en_US.8859-1 en-US 'EURO', 97166 879.90 8799
> 6 it_IT.8859-1 en_US.8859-1 it-IT 'EURO', 879,9 72,16 72,16
> 7 it_IT.8859-1 it_IT.8859-1 en-US 'EURO', 7216 495.84 49584
> 8 it_IT.8859-1 it_IT.8859-1 it-IT 'EURO', 495,84 818,59 818,59
>
> The above table of data has been generated by the following VB .Net code:
> #######################--BOF--####################
> Module database
[...snip...]
> End Module
> #######################--EOF--####################
>
> It seems to respect the decimal separator only when "application culture"
> matches gls dbmoney decimal separator (with or without explicit declaration).
>
> NB: I set the wrong value of dbmoney: 'EURO', instead of 'EURO,' unfortunately
> I realized it just now.
>
> This problem has been fixed and will be available for the next release of CSDK
> 290 TC5.
Well, that's not very surprising. GLS was introduced into IDS 7.20;
IDS 7.1x does not support GLS. Just another reason you're overdue for
an upgrade.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Messages In This Thread

Re: Decimal values without decimal separator?!
Jonathan Leffler -- Thursday, 9 February 2006, at 1:27 a.m.
- Re: Decimal values without decimal separator?!
  BENIAMINO SARNO -- Thursday, 9 February 2006, at 9:33 p.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Development Tools Forum is maintained by Administrator with WebBBS 5.12.