All:

I am getting an unexpected error doing string->date conversions when the
database locale is UTF8.

When I run the following test queries:

SELECT
TO_DATE('1900-01-01 00:00:00')
FROM systables WHERE tabid = 1;

SELECT
TO_DATE(CAST(CURRENT YEAR TO SECOND AS varchar(40)))
FROM systables WHERE tabid = 1;

against a UTF8 database, I get this:

1277: Input does not match format specification.

Running the same queries against sysmaster (or any other non-UTF8
database) on the same server works properly. Exporting the UTF8 test
database I first observed this on and importing it as new non-UTF8
database also lets the above queries work properly.

I observe this behaviour on 10.00.UC5W5 and 11.50.UC6WE

Can anyone confirm this? Is this a known issue? Is there a known
workaround or fix? If there's nothing simple that I'm missing here, we'll
take it to IBM/Informix support. I'm guessing this is an engine issue that
will require a patch.

Thanks!

--
John Hardin KA7OHZ
Senior Applications Developer, BI Specialist
EPICOR Retail
web: http://www.epicor.com
voice: (425) 245-1800
fax: (845) 926-4104
email: <jhardin (AT) epicor (DOT) com>
20818 44th Ave. W., Suite 270
Lynnwood, WA 98036 USA
Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA

--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---