We are having an issue with our Informix database and querying
information where there is a Horizontal Ellipse (...) in the data
column. Our user interface doesn't limit which characters a user
inputs and some are copying and pasting data from a MS Word document
which sometimes pastes in the Horizontal Ellipse (...).

The problem is that when we try to query the data through an ODBC
Connection the query will their error out or lock up the whole ODBC
service on our web server taking the website down.

Anyone have experiences with this or an idea on how to get around
this?

We are running informix 11.5 and using an ODBC Connection to query
data from ColdFusion MX7.

Thanks,

James

On Jul 15, 3:27*pm, "J. Hart" <unleashedman... (AT) gmail (DOT) com> wrote:

I think I finally worked out a solution for this. I upgraded my
Informix ODBC Drivers to the latest version (ver 3.70) and under the
ODBC Driver Setup, I changed my Client Locale from "en_US.CP1252" to
"en_US.819".

Hope this helps anyone else.

James

What is your settings for CLIENT_LOCALE and DB_LOCALE on your query tool
environment AND your application environment?
What versions of the client SDK are you using?

I suspect you have a very complex issue on your data, but the solution maybe
simple.
Also include the error you get when the query tool raises an error.
Was your system recently upgraded?

Regards.

On Fri, Jul 15, 2011 at 11:27 PM, J. Hart <unleashedmaniac (AT) gmail (DOT) com> wrote:



--
Fernando Nunes
Portugal

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

On Aug 19, 10:17*am, Fernando Nunes <domusonl... (AT) gmail (DOT) com> wrote:
I'm not sure about the CLIENT_LOCALE on my query tool. I was not able
to find it listed anywhere. The DB_LOCALE is "en_US.819".

The application environment was: Client Locale = "en_US.CP1252" and
Database Locale = "en_US.819", which I guess were the default settings
because I didn't change these when setting up the ODBC.

My old SDK I was running was "2.90 TC6R1". I just upgraded the SDK to
"3.70 TC3DE". and changed both my locale on my ODBC to "en_US.819".

This seems to be working fine and any special characters are just
getting converted to a space " ", which is fine for me.

I wasn't getting a special error, the ODBC Connection/Service just
locked up and I would have to force it to restart.

We didn't recently upgrade anything that caused this issue. The issue
has randomly been happening since we rolled out the application. It
wasn't until I did some extensive troubleshooting that I figured out
that it was the Horizontal Ellipse (...) causing the problem. I
remember seeing in a database forum somewhere that these characters
could be Locale specific which caused me to look into that as a
solution.

Thanks,

James