date problem

From: Jeff Kish <jeff.kish_at_mro.com>
Date: Thu, 25 Jan 2007 12:46:24 -0500
Message-ID: <8iphr29d5jo0ef113t5i97k2bn2aliaf61@4ax.com>

Hi.
I have some software (really old stuff) I maintain. It never had any internationalization or anything (its really old). It runs on windows and interfaces with a database (in this case Oracle) via a 3rd party "c++" accessible library.

Recently an install happened in a Spanish speaking country.

It seems that some record inserts were failing with the message:

a non numeric character was found where a numeric was expected This query I believe reveals the character set:

SQL> select SYS.PROPS$.VALUE$ from SYS.PROPS$ where ((SYS.PROPS$.NAME = 'NLS_CHARACTERSET'));       VALUE$

---

WE8ISO8859P1 I believe the basic embedded sql which has not failed in the past used this sql:

INSERT INTO table( id, newpass, thedate )VALUES ( :userid, :pswd,

                 TO_DATE( :thedate, 'DY MON DD HH24:MI:SS YYYY' ) )

Note the colons prefix names used to bind values in the embedded system.

I thought the TO_DATE would 'fix' things up properly.. I'm not sure how to analyze the problem to determine the cause.

Thanks for any suggestions,

Jeff Kish Received on Thu Jan 25 2007 - 11:46:24 CST