Skip to main content
Participant
November 30, 2009
Question

Database local settings : difference between CF5 and CF9

  • November 30, 2009
  • 1 reply
  • 515 views

Hello,

We are going to migrate from CF5 to CF9. A simple test give me differents result on CF5 and CF9 platforms, trying to retrieve data from an Oracle Database :

Here is the code :

<cfquery name="nb" datasource="#DSN_prod#">

select 1234/10 as nbr

from dual

</cfquery>


<cfquery name="t" datasource="#DSN_prod#">

select sysdate as dt

from dual

</cfquery>


#nb.nbr#<br>

#t.dt#<br>

#GetLocale()#

The result on CF5 :

123,4
30/11/09

English (US)

The result on CF9 :

123.4
2009-11-30 18:37:47.0

French (Standard)

On CF5, the number and the date are in the French Format, however the Locale is English (US).

On CF9, the number is in the English Format, however the Locale is French !

Does anyone know if a server setting exists to configure the date and number format from a query result ?

This topic has been closed for replies.

1 reply

Inspiring
January 12, 2010

Is it the same DB you're connecting to in both cases?  I presume so, but figured I should ask.

Given you're not applying any formatting (like  lsDateFormat(), for example), it suggests that it's not CF doing anything, but that's the actual data coming back from the DB.  But if ti's the same DB in both cases, it could be the DB driver trying to "help".

What driver are you using on each CF server?

--

Adam