[freetds] Problem with smalldates in SP

James K. Lowden jklowden at freetds.org
Sat Oct 1 09:44:25 EDT 2005


Carlo Andreoli wrote:
> It's my fault, because in the "Connection attributes" page of the
> FreeTDS User Guide's chapter 4, it's explained that the language default
> for the odbc connections is us_english. However, let me say that it's
> not explained that this parameter determines also the dateformat
> setting. In fact, it says only: "(Human) language the server should use
> for error messages."

Carlo, 

Thanks for pointing that out.  It says that because, er, I didn't know
about that interaction.  Still don't, actually, except for your mail.  

I knew that the language setting is a property of the connection.  On a
Win32 box, one has the option of "using regional settings" or somesuch.  I
know that affects how date strings are rendered to the user, and I've seen
problems with inserting dates when our UK friends set the dateformat to
mdy.  I didn't know that the server would infer the dateformat from the
language specified at login.  

I wonder what else is affected?  When I understand it better, I'll update
the UG.  

--jkl


More information about the FreeTDS mailing list