Save 
Join IIUG
 for   
 

Informix News
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter


RSS Feed: IIUG Forum: Open Admin Tool

More IIUG RSS Feeds

Classics is a forum to discuss all aspects of Informix classic tools including Standard Engine (SE), Online 5, 4GL, D4GL, ESQL, ISQL and others.


URL: http://www.iiug.org/rss/classics.rss

Below is the latest content available from this feed:

ISQL for Windows?
Posted by: frank_in_pr@hotmail.com (FRANK J. COMPUTER) - Wed, 02 May 2012 22:25:08 EDT
For what its worth, there would be value and worthwhile for IBM to port
INFORMIX-SQL to the Windows environment. Believe it or not, there still are a
ton of ISQL-DOS based apps running out there since 1990!.. Mine is one of them
ISQL2.10.06E and 4.10DD6. I have it running with no problems on MS-DOS 6.22 in
both native DOS machines as well as within Microsoft Virtual PC 2007 on
Windows 7 7, Vista and XP. I also have my app integrated with Microsoft Office
Excel, Word, Access. The DOS drive F: is linked to a USB flash drive, LPT1:
linked to HP Laser printer, drive W: linked to Windows Desktop and several
other logical DOS drives to other Windows folders.. There still is value in
ISQL for quickly prototyping an app, development purposes and to migrate to
the UX world!.. I recently installed Informix 11.70 for Windows and noticed
that dbaccess is very similar to the isql menu driven interface (minus Perform
and Ace).. How much of an effort would be involved in porting ISQL to
Windows?.. I'd like to help, if necessary!




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4116]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Great Genero new video from IBM
Posted by: neilom@4js-emea.com (Neil O'Meara) - Wed, 02 May 2012 15:06:13 EDT
IBM have today put this great new video on youtube which really
highlights the case for the use of Genero for the production of new
systems as well as for modernizing old I4GL apps.

http://www.youtube.com/watch?v=jybEkP-ft2Y&feature=youtu.be

Neil O'Meara




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4115]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: INFORMIX 4GL/SQL on Windows
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 01 May 2012 10:06:49 EDT
They have had some success.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Tue, May 1, 2012 at 2:29 AM, FRANK J. COMPUTER
<frank_in_pr@hotmail.com>wrote:

> So, as I had suggested more than a year and a half ago that IBM should
> co-label and market a third-party I4GL-compatible GUI version for
> Windows/Linux, it came true about a year ago with 4Js Genero Suite, and I
> was
> wondering how much success IBM has had in marketing this product?
>
>
>
>

>
>
>

--14dae9340d599e363804befa14a6




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4114]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: INFORMIX 4GL/SQL on Windows
Posted by: frank_in_pr@hotmail.com (FRANK J. COMPUTER) - Tue, 01 May 2012 02:29:05 EDT
So, as I had suggested more than a year and a half ago that IBM should
co-label and market a third-party I4GL-compatible GUI version for
Windows/Linux, it came true about a year ago with 4Js Genero Suite, and I was
wondering how much success IBM has had in marketing this product?




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4113]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Strange Perform forms behavior
Posted by: frank_in_pr@hotmail.com (FRANK J. COMPUTER) - Tue, 01 May 2012 02:03:26 EDT
Perhaps you need to check the terminfo entry for the vt100 emulation.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4112]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

JDBC remote connection to Informix SE 7.22
Posted by: craig@coot.net (CRAIG ANDERSON) - Sat, 31 Mar 2012 13:01:38 EDT
I work at a call center with a number of older phone switches that use
Informix for reporting. OS and Informix releases are:

INFORMIX-SE 7.22.UC2
64-bit UltraSPARC release. Solaris 7 SunOS 5.7

I'm working on connecting to the report database and developing some custom
reports.
The remote report box will be running windows, my preference is use Java
(JRuby actually)
and a JDBC interface. I have installed the Informix JDBC Driver jar files
version 3.70.JC4 from IBM.

So far I've collected some JDBC examples and demonstrated that I can import
the
com.informix.jdbc.IfxDriver and java_import java.sql.DriverManager classes.
I'm working on the Connection URL string to use and trying to verify that the
TLI using TCP/IP is configured to allow the remote connection.

This is a fun project for me, I'll report success and ask questions as I go.

I'm hoping there are some folks with experience doing this on the forum.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4111]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Anyone created isql cperf/cace custom runners?
Posted by: frank_in_pr@hotmail.com (FRANK J. COMPUTER) - Tue, 27 Mar 2012 21:51:28 EDT
INFORMIX-SQL 4.10 DD6 (DOS 6.22 on Microsoft Virtual PC 2007) or any isql on
Linux:

Has anyone ever created custom runners with several cfuncs for features not
supported in 4.10 SE, but available for OnLine or IDS?




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4110]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SQL(-211,-107,0) Cannot read system Catalog
Posted by: sdmv7586@gmail.com (MANIVANNAN CHANDRASEKARAN) - Wed, 08 Feb 2012 00:08:32 EST
Thanks Fernando.

Thanks John.

I have removed the BEGIN WORK.

Now the query is preparing succesfully.

Thank you very much for the support.

Cheers,
Manney




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4109]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Character set encoding incompatibility
Posted by: robert.kruse@galaxyhotelsystems.com (BOB KRUSE) - Tue, 07 Feb 2012 15:19:23 EST
Hi Jonathan,

Thanks for the great explanation. We're using the Informix 3.50 JDBC driver to
connect to Online from the JBoss app server. We're still looking into this but
it looks like the application server is performing the codeset conversion but
the application is not sending the properly formatted message. It sends the
text in an email message. One message is properly formatted and another it
sends out is not. So I think we have more to dig into in the application.

Thanks,

Bob




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4108]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SQL(-211,-107,0) Cannot read system Catalog
Posted by: miller3@us.ibm.com (John Miller iii) - Tue, 07 Feb 2012 11:15:14 EST
In short, a best practice for update statistics is....

NEVER run it inside an BEGIN/COMMIT.

If you let update statistics manage the transaction
you will be much happier.

John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
(Embedded image moved to file: pic38582.gif)

classics-bounces@iiug.org wrote on 02/07/2012 06:45:20 AM:

> From: "Fernando Nunes" <domusonline@gmail.com>
> To: classics@iiug.org
> Date: 02/07/2012 06:49 AM
> Subject: Re: SQL(-211,-107,0) Cannot read system Catalog [4106]
> Sent by: classics-bounces@iiug.org
>
> One of the most read articles...
> Update statistics must update data in systables. If you run it inside a
> transaction and keep it opened than you'll keep the lock...
>
> This used to happen "automatically" with ANSI databases (fixed in
11.50.xC6
> I believe).
> Regards.
>
> On Tue, Feb 7, 2012 at 11:33 AM, MANIVANNAN CHANDRASEKARAN <
> sdmv7586@gmail.com> wrote:
>
> > I was browsing some information on Fernando Nunes's Blog and found this

> > information
> >
> >
> >
> http://informix-technology.blogspot.in/2006/10/when-exclusive-is-
> not-really-exclusive.html
> >
> > When trying to reproduce the same scenario i noticed that there is
another
> > script getting executed in parallel which executes update statistics on
few
> > tables used in the select query which failed..
> >
> > This update statistics was embedded in a transaction.
> >
> > --
> > BEGIN WORK;
> > UPDATE STATISTICS FOR TABLE clm_surrender;
> > COMMIT;
> > --
> >
> > Whether this will create an exclusive lock on table - clm_surrender ?
> >
> > Please advice.
> >
> > Cheers,
> > Manney
> >
> >
> >
> >
>



> >
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --00248c769136c7b67f04b860d3f7
>
>
>



>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4107]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SQL(-211,-107,0) Cannot read system Catalog
Posted by: domusonline@gmail.com (Fernando Nunes) - Tue, 07 Feb 2012 09:45:21 EST
One of the most read articles...
Update statistics must update data in systables. If you run it inside a
transaction and keep it opened than you'll keep the lock...

This used to happen "automatically" with ANSI databases (fixed in 11.50.xC6
I believe).
Regards.

On Tue, Feb 7, 2012 at 11:33 AM, MANIVANNAN CHANDRASEKARAN <
sdmv7586@gmail.com> wrote:

> I was browsing some information on Fernando Nunes's Blog and found this
> information
>
>
>
http://informix-technology.blogspot.in/2006/10/when-exclusive-is-not-really-exclusive.html
>
> When trying to reproduce the same scenario i noticed that there is another
> script getting executed in parallel which executes update statistics on few
> tables used in the select query which failed..
>
> This update statistics was embedded in a transaction.
>
> --
> BEGIN WORK;
> UPDATE STATISTICS FOR TABLE clm_surrender;
> COMMIT;
> --
>
> Whether this will create an exclusive lock on table - clm_surrender ?
>
> Please advice.
>
> Cheers,
> Manney
>
>
>
>

>
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--00248c769136c7b67f04b860d3f7




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4106]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SQL(-211,-107,0) Cannot read system Catalog
Posted by: sdmv7586@gmail.com (MANIVANNAN CHANDRASEKARAN) - Tue, 07 Feb 2012 06:33:14 EST
I was browsing some information on Fernando Nunes's Blog and found this
information

http://informix-technology.blogspot.in/2006/10/when-exclusive-is-not-really-exclusive.html

When trying to reproduce the same scenario i noticed that there is another
script getting executed in parallel which executes update statistics on few
tables used in the select query which failed..

This update statistics was embedded in a transaction.

--
BEGIN WORK;
UPDATE STATISTICS FOR TABLE clm_surrender;
COMMIT;
--

Whether this will create an exclusive lock on table - clm_surrender ?

Please advice.

Cheers,
Manney




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4105]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

SQL(-211,-107,0) Cannot read system Catalog
Posted by: sdmv7586@gmail.com (MANIVANNAN CHANDRASEKARAN) - Tue, 07 Feb 2012 06:18:34 EST
Hi Gurus,

Need your help & suggestions for this error.

Suprisingly one of my query which worked fine before is failing now in the
prepare part itself.

The error log contains the following error code.

<--
SQL(-211,-107,0) [systables] Cannot read system catalog (systables).

ISAM error: record is locked.
-->

My select query contains only transactional tables from different databases.
Table - systables was not used in my select query.

I am using Informix 11.5 version on HP UNIX.

Kindly let me know if any more info is needed.

Cheers,
Manney




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4104]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: RE: Identifying a New Line Character with ....
Posted by: douglawry@hotmail.com (Doug Lawry) - Mon, 06 Feb 2012 17:22:26 EST
Happy to help, Cynthia!

Regards,
Doug Lawry

-----Original Message-----
From: classics-bounces@iiug.org [mailto:classics-bounces@iiug.org] On Behalf
Of CYNTHIA SCOTT
Sent: 06 February 2012 21:03
To: classics@iiug.org
Subject: Re: RE: Identifying a New Line Character with .... [4102]

Thank You Very Much. That works!!

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
***





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4103]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: Identifying a New Line Character with ....
Posted by: clscott@klcorp.com (CYNTHIA SCOTT) - Mon, 06 Feb 2012 16:03:24 EST
Thank You Very Much. That works!!




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4102]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Identifying a New Line Character with a Query
Posted by: paul@oninit.com (Paul Watson) - Mon, 06 Feb 2012 15:45:01 EST
Install the RegExp datablade

Cheers
Paul

> EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t');
>
> SELECT * FROM table-name
> WHERE column MATCHES '*
> *';
>
> Regards,
> Doug Lawry
>
> -----Original Message-----
> From: classics-bounces@iiug.org [mailto:classics-bounces@iiug.org] On
> Behalf
> Of CYNTHIA SCOTT
> Sent: 06 February 2012 20:02
> To: classics@iiug.org
> Subject: Identifying a New Line Character with a Query [4099]
>
> Does anyone have a query that can help identify embedded New Line
> characters?
> We have a new interface to one of our Informix v10.0 databases that is
> including these characters in the data and we need to find them and
> replace.
>
> Thanks Much
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> ***
>
>
>
>

>
>

--
Paul Watson
Tel: +1 913-674-0360
Mob: +1 913-387-7529
Web: www.oninit.com

www.advancedatatools.com

Failure is not as frightening as regret.
If you want to improve, be content to be thought foolish and stupid.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4101]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Identifying a New Line Character with a Query
Posted by: douglawry@hotmail.com (Doug Lawry) - Mon, 06 Feb 2012 15:37:40 EST
EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t');

SELECT * FROM table-name
WHERE column MATCHES '*
*';

Regards,
Doug Lawry

-----Original Message-----
From: classics-bounces@iiug.org [mailto:classics-bounces@iiug.org] On Behalf
Of CYNTHIA SCOTT
Sent: 06 February 2012 20:02
To: classics@iiug.org
Subject: Identifying a New Line Character with a Query [4099]

Does anyone have a query that can help identify embedded New Line
characters?
We have a new interface to one of our Informix v10.0 databases that is
including these characters in the data and we need to find them and replace.

Thanks Much

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
***





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4100]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Identifying a New Line Character with a Query
Posted by: clscott@klcorp.com (CYNTHIA SCOTT) - Mon, 06 Feb 2012 15:02:12 EST
Does anyone have a query that can help identify embedded New Line characters?
We have a new interface to one of our Informix v10.0 databases that is
including these characters in the data and we need to find them and replace.

Thanks Much




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4099]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Character set encoding incompatibility
Posted by: jonathan.leffler@gmail.com (Jonathan Leffler) - Fri, 03 Feb 2012 11:14:32 EST
On Thu, Feb 2, 2012 at 13:04, BOB KRUSE <robert.kruse@galaxyhotelsystems.com
> wrote:

> I'm loading French text into our Informix 5 database server to be read by
> our
> Java application which accesses the database server through a JBoss
> application server. The character set for Informix 5 is the default
> ISO8859-1.
> The setting we have for the JBoss application server is UTF-8. This seems
> to
> be causing some problems with transposition of characters when the
> application
> prints the French text. The French text is part of the extended ASCII
> character set. Has anyone had any experience with this and any suggestions
> on
> how we could resolve this issue?
>
> A sample is:
>
> Informix: Nous espérons que vous avez apprécié votre expérience récente<CR>
>
> Java String: Nous esp�rons que vous avez appr�ci� votre exp�rience
> r�cenn.<CR>
>

In 8859-1, the byte value for ï is 0xEF, for ¿ is 0xBF, for ½ is 0xBD, for
é is 0xE9. Somehow, you are getting a triple 0xEF, 0xBF, 0xBD. When
treated as a UTF-8 character, that represents U+FFFD, which is REPLACEMENT
CHARACTER 'used to replace an incoming character whose value is unknown or
unrepresented in Unicode'. The 0xE9 byte is itself valid in UTF-8, but
only if it is followed by 2 continuation bytes in the range 0x80..0xBF
(which it is not in this example). It so happens that your text only shows
é (LATIN SMALL LETTER E WITH ACUTE in Unicode jargon); I imagine that any
other character from ISO 8859-1 in the range 0x80..0xFF also appears as the
鿽 sequence.

So, it appears likely to me that the data is stored accurately in the
database in 8859-1, but the client software is unaware that it needs to do
codeset conversion from 8859-1 to UTF-8. So, when the Java code sees the
0xE9 byte, it looks for continuation bytes, doesn't find them, and maps the
invalid character to the replacement character. (The alternative would be
to reject the data altogether.)

Informix OnLine 5 pre-dates the GLS (Global Language Support) functionality
that would allow for different code sets to be handled properly.

I wonder - which software are you using to connect JBoss to OnLine?

Can you configure it to do codeset conversion between UTF-8 and 8859-1 as
it travels between the client and the server. In GLS, the client is
expected to do the codeset conversion. That is, the GLS-enabled clients
convert strings from the client 'locale', meaning codeset, as specified by
the CLIENT_LOCALE environment variable, to the database 'locale' (codeset)
as specified by the DATABASE_LOCALE environment variable. The ESQL/C 5.x
software does not do this; it was never specified to do so.

If you need both UTF-8 and 8859-1 to be stored, then the best solution is
an upgrade to IDS 11 (earlier versions of IDS, from 7.20 onwards, have GLS
support but are out of marketing and/or service now) and the corresponding
CSDK and JDBC. That is a moderately major exercise though.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

--14dae9340f9d5af02504b8119bfc




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4098]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Character set encoding incompatibility
Posted by: robert.kruse@galaxyhotelsystems.com (BOB KRUSE) - Thu, 02 Feb 2012 16:04:17 EST
Greetings,

I'm loading French text into our Informix 5 database server to be read by our
Java application which accesses the database server through a JBoss
application server. The character set for Informix 5 is the default ISO8859-1.
The setting we have for the JBoss application server is UTF-8. This seems to
be causing some problems with transposition of characters when the application
prints the French text. The French text is part of the extended ASCII
character set. Has anyone had any experience with this and any suggestions on
how we could resolve this issue?

Thanks,

Bob

A sample is:

Informix: Nous espérons que vous avez apprécié votre expérience récente<CR>

Java String: Nous esp�rons que vous avez appr�ci� votre exp�rience
r�cenn.<CR>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4097]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Greetings,

I'm loading French text into our Informix 5 database server to be read by our
Java application which accesses the database server through a JBoss
application server. The character set for Informix 5 is the default ISO8859-1.
The setting we have for the JBoss application server is UTF-8. This seems to
be causing some problems with transposition of characters when the application
prints the French text. The French text is part of the extended ASCII
character set. Has anyone had any experience with this and any suggestions on
how we could resolve this issue?

Thanks,

Bob

A sample is:

Informix: Nous espérons que vous avez apprécié votre expérience récente<CR>

Java String: Nous esp�rons que vous avez appr�ci� votre exp�rience
r�cenn.<CR>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4097]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Readerv