[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