Database local settings : difference between CF5 and CF9
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 ?
