[freetds] Problem with smalldates in SP
James K. Lowden
jklowden at freetds.org
Sat Oct 1 20:57:51 EDT 2005
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.
More information about the FreeTDS
mailing list