Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to set locales.conf in spanish

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] How to set locales.conf in spanish
  • Date: Sat, 11 Jan 2003 15:15:14 -0500

On 11 Jan 2003 14:24:45 +0100, Frediano Ziglio <freddyz77 AT tin.it> wrote:
> > I really feel like we're talking past each other, here. I understand
> > "collation" in the sense of the LC_COLLATE env var: that is, a sort
> > order. Isn't this for things like 'SELECT xx,yy FROM zz ORDER BY
> > foo'? When would the client need to know details about the collation
> > order?
>
> Mm... we are speaking of different things...
> For collation I mean "sql collation", non "c collation"
...
>SELECT CONVERT(VARCHAR(80), @string) COLLATE Greek_bin

Ah. I wondered why you called those 5 bytes "collation". Does anyone
know if that's SQL-92? It looks like a Microsoftism to me.

You finally cornered me into downloading the SQL 2000 BOL. I normally
rely on my installed 7.0 docs at work, partly because I've only got one
Microsoft box around, and it dual-boots Linux so I can run Sybase. I'll
have to read up on the above syntax, also the xml stuff.

Steve, in case you didn't follow our thread last month, TDS 8.0 passes
"code page" and collation information per column. Frediano deciphered
most of it, but it hasn't found its way into tds.h yet. It seems that one
of 2000's features is to be able to localize individual columns (rather
than a whole server). Whether a client would honor that sort order or
apply its own would be the client's choice, but at least it's got the
server's notion in case it wants it. It also might be helpful to (ahem)
ascii clients, who otherwise have no way to know what encoding was used
for a given varchar column.

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page