Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with smalldates in SP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with smalldates in SP
  • Date: Sat, 1 Oct 2005 09:44:25 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page