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: TDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem with smalldates in SP
  • Date: Sat, 1 Oct 2005 20:57:51 -0400

Igor Korot wrote:
> Basically, I think if you look in the "Control Panel->RFegional
> Settings" in the Windows XP/NT, you will see pretty much what's affected
> by this option.

Yes, I know about the regional settings. I think they mostly determine
the behavior of a) certain clients (e.g. Query Analyzer) or b) the ODBC
driver. I think most of them don't affect the server.

sp_helplanguage: http://tinyurl.com/7pb7s

I think currency rendering, for example, is driven by locale. There's
nowhere in the login packet (afaik) to set the lcid. Is it inferred from
the language?

http://www.freetds.org/tds.html#login7

Two bytes (56 & 57) in the TDS 7.0 login packet have an unknown purpose.
Perhaps they can carry locale information? Probably not; we at least
always send zeros.

I think we need some more testing before we (or at least I) know exactly
what's affected by the language field in the login packet.

--jkl


> 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.




Archive powered by MHonArc 2.6.24.

Top of Page