FreeTDS Development Group

["Chad Tullis" <CTULLIS AT arvest.com>]

I will be out of the Office the week starting December 8th.  If you need
immediate assistance please contact the Arvest Help Desk at
501-750-6900.


Thanks,
Chad Tullis

>>> freetds 12/08/02 11:00 >>>

Send FreeTDS mailing list submissions to
        freetds AT lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
        freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
        freetds-admin AT lists.ibiblio.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of FreeTDS digest..."


Today's Topics:

   1. RE: collate and TDS8 (Frediano Ziglio)
   2. Re: collate and TDS8 (James K. Lowden)

--__--__--

Message: 1
Subject: RE: [freetds] collate and TDS8
From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS <freetds AT lists.ibiblio.org>
Organization: 
Date: 07 Dec 2002 18:26:40 +0100
Reply-To: freetds AT lists.ibiblio.org


--=-uGRiBr9YRwlH0sXqO20t
Content-Type: text/plain
Content-Transfer-Encoding: 7bit


> > > > > - 2 bytes ???
> > > > 
> > > > My next two bytes are always 00 01:
> > > > 
> > > 
> > > Mines are 0d 00 (0xd0 in LE??)...
> > > Full lcid on windows as also sort (bits 19-16) and version 
> > > (bits 23-20)
> > 
> 
> Perhaps 
> Mine 0xd0 -> 0000 0000 1101 0000 -> third: 1 width insensitive 1
> katatype insensitive 0 accent sensitive 1 case insensitive
> Yours 0x100 -> 0000 0001 0000 0000 -> second: 0 0 0 1 binary third
0000
> all insensitive.
> Other bits ??
> 

Last nibble of bytes 2-3 is language modifier. Last byte is id or 0
Other bits confirmed, see also attachment (extracted from query I send
in previous mail)

So now we know all bits of collation info. Problem is to use all info
and how...

freddy77


--=-uGRiBr9YRwlH0sXqO20t
Content-Disposition: attachment; filename=show.txt.gz
Content-Type: application/x-gzip; name=show.txt.gz
Content-Transfer-Encoding: base64

H4sICEwt8j0AA3Nob3cudHh0AI2cXY/byBFF3/Mr9jlAAPFT5COH5GwcZQMndJJHQ2sr8WDHo4U8
u5vk12c0I7JONau6CRjwwz11u9hzu0lJLe3KrP9ul+123738+8N333WPPx6fHo5PH+/e/eX3v9u9
qrv7ldq/+9i9W/S9rX/857Qgdw5yEKRwERoNJiV6Zeu0aB0EvWQuQqNxTU2cl9rWadE5CHrJXYRG
vUmJXto6LRoHQS/rnMzIzWiXqTRdjj8+fJqzdNWQpTdtSdKrurdUWCNHBA4CFA5Ak8FgRK0sleWt
CaCHzAFoMobMxHmoLZXlnQmgh9wBaNIbjKilpbK8MQH0EOZAZ6XZlcxK/+Xh6fTt9PH93/pbYF4B
CQyBOTVvyN5FMJJEZ00dhCpiFO0GDxSkchEatT6FvrIYRbvRBCfOV+0iNOp8Cn3lMYp2vQcKUroI
jRqfQl9mrswA5gY4PV/OP510DiNcEMcUqVKZhBnODbDKaIJHVFOkSmwSZnA3wCq/MV7HOEWqNCdh
hnoDrLKd4BHxFKmSnoQZ+A3wvHu/5r4I+A/Hh9+uD37nn89fz/86L3ft1/CnYLmNv66ATTi62d1t
qzhIRbG1gsMMW4oErzbhHKDdVoHryLZWcJgxWTTx71FvwjlAt60C15FvreAw/ZYiwctNOAdotlXg
OpLrwlxM4d3mVqTuI6X9PKPRYCFtgNUy2sJzEW3j1RJKl2ABbYDV8tnCc/Fs49XSSZTohbMBVstm
C89Fs41XSyZdggWzAVbLZQvPxbKNn19ldmqpXM7HZ77V0KnVMavyVkOnFoTSMQDWgEYOghQuQqPB
pESvbJ0WrYOgl8xFaDSuqYnzUts6LToHQS+5i9CoNynRS1unReMg6GWdkzBNrUrTfy8Pj48vLzK/
Pz2dLsfHJVWtSlVISbpalS6Tw8BImY0eBC2SKI2HKC1cFedo2SZQ9JolURqPPj1xXus4R8sugaLX
PInSuI/SwpVxjpZNAkWvfk7Dx4lKpfp/p09flseHSkX5VZLHhUrlV0T4IrTQD6IXtk6LYY2IWBki
i1tLx/iZrdNiDJCJ118bIos7S8f4ua3Tol8jIpaGyOLG0jH+ztZni5rRGI5PD9++fPzL+fLb6d+4
jV4pScmKksDUDIzNYWDJjoMeBC2SKI2HKC1cFedo2SZQ9JolURqPPj1xXus4R8sugaLXPInSuI/S
wpVxjpZNAkWvfk6DVOdqwxu/PZ/5+VOu9rxFXVKcq21P6xhA0hsgB0EKF6HRYFKiV7ZOi9ZB0Evm
IjQa19TEealtnRadg6CX3EVo1JuU6KWt06JxEPSyzkm4R94xTfcPT6/hm347fb7+P2+RdwxVCMkO
ecdsmRhGlYjZ5EHIIkXSdojBglVRjIZtnESfWYqk7ejCE+ezjmI07OIk+sxTJG37GCxYGcVo2MRJ
9OnmMgyx+kj+/nJ6wkOg+kD+pklk1cfxVGGNpBI4CFA4AE0GgxG1slSWtyaAHjIHoMkYMhPnobZU
lncmgB5yB6BJbzCilpbK8sYE0EOYgyArxf6alezGfH86X15vsj+cP58uTx+/nS/Pc3Ku5O4+Si45
emX3aRZN7O424AfBi004BxiSFcJWaZbW7QYcvWebcA4wxismznudZmndbcDRe74J5wB9skLYMs3S
utmAo/d4zsNdNFgZl68v/Psv56fT3fn807KfBqsioGRnDVaExWFgrgYTPQhaJFEaD1FauCrO0bJN
oOg1S6I0Hn164rzWcY6WXQJFr3kSpXEfpYUr4xwtmwSKXv2chqlu+Gzw/eV0kig3fDR4kyS/DZ8M
IMJXHgyoH0QvbJ0WwxoRsTJEFreWjvEzW6fFGCATr782RBZ3lo7xc1unRb9GRCwNkcWNpWP8na3P
FgOj8cfTj5fTb0s2Bmbjpkk4BoaDKqwlHQo4CFA4AE0GgxG1slSWtyaAHjIHoMkYMhPnobZUlncm
gB5yB6BJbzCilpbK8sYE0EOYgzAro8rKL0//Pl74JuKo4rLIkphRJUYDGAOhCZiDMIXP0GqwMQEq
B6BJ6zHoJ/MZWo0GNnF+agegSecx6Cf3GVr1NiZA6QA0aTwG/Ri5MeOVrbAPp09fnh4+ycdzb0GL
gUHkkqgKX5pmDLfQKpCpAkQziaqQpmnGdQutghst0BFOoirMaZqx3kKrgKcKEPUkqkKfphn/LfRs
f8999t2n0+Px6TOOxN9znxVZQn/PfTYAMIbssyFzEKbwGVoNNiZA5QA0aT0G/WQ+Q6vRwCbOT+0A
NOk8Bv3kPkOr3sYEKB2AJo3HoB8jN+EZCPV1iz8dfz6+nsKZzz6oL1wsqpx5UF+50DoGkGwFyEGQ
wkVoNJiU6JWt06J1EPSSuQiNxjU1cV5qW6dF5yDoJXcRGvUmJXpp67RoHAS9rHNipikLqb+/7Gzn
z0GqXCpIV5xTKUugTFsSVamL0khfnFMpTKBMYxJVqfRpnc44p1KaQJnWJKpSG6WR3jinUpxAmeYk
Ohvn3CMP58vp5Yb9z+PTt5e795LpnDtlwEiic+6XFoUhZdc0wYOARQKk6RBhhapiFO3aKIgeswRI
09FjJ85jHaNo10VB9JgnQJr2EVaoMkbRromC6NHLoZnZzGbD/TjnfuywQYa30CrLmwqY6Y0FKtsb
apDxLbTK+qYCZn5jgcp+qkavgS20WgubCrgmNhaotbGhBmtkC63WyqYCrpmNBfPjtToX/Ofj88NT
Fp4K3qlTwQEjL77UmWCLwpCy35vgQcAiAdJ0iLBCVTGKdm0URI9ZAqTp6LET57GOUbTroiB6zBMg
TfsIK1QZo2jXREH06OUwPARXB5n9lWfg1InOWZQjcOogp5LhruIJ4iBE4RG0GSxI5MqUadDaBPrI
PII24wqaOB+1KdOgswn0kXsEbXoLErk0ZRo0NoE+VrkIw7NX4Xl4/vKL+g2PfK/yI7pEaK8iFBAY
BikKoYNARQSi2eBwQlQeQZvWhdBTFoFoNlrcxHmqPYI2nQuhpzwC0ax3OCFKj6BN40LoycqRzlvj
5q1/PH77try52fi5u3Fz/ho/fyQxvJ1DBR8ENvMYwDQ3cwleSDOfJGlr5lTB6NnMawDT3MztzE+c
ZzO/JGlr5ljB6NnMcwDT3Mw1eCHNfJOkrZlzBaPnWI7DfVa9l//D8dPpsz6rrt7Mhy77rHo3PyQw
jOR7BR0EKiIQzQaHE6LyCNq0LoSesghEs9HiJs5T7RG06VwIPeURiGa9wwlRegRtGhdCT1aOdN76
nfq67O2k2/Tz2/cp3jL3yiBzmplz90btYxSGRPYs8CBgkQBpOkRYoaoYRbs2CqLHLAHSdPTYifNY
xyjadVEQPeYJkKZ9hBWqjFG0a6IgevRyGL5xpb7N8/78iK9dZOq7PDdN3phS3+ShCmvJpgIOAhQO
QJPBYEStLJXlrQmgh8wBaDKGzMR5qC2V5Z0JoIfcAWjSG4yopaWyvDEB9BDmIMyKOsr4t/NX/cuD
6jTjokpe1IFGrWMASUyAHAQpXIRGg0mJXtk6LVoHQS+Zi9BoXFMT56W2dVp0DoJechehUW9Sope2
TovGQdDLOidhmtQ3v6bH86/H5WRspr7wddMkSep7XlRhLTlSwEGAwgFoMhiMqJWlsrw1AfSQOQBN
xpCZOA+1pbK8MwH0kDsATXqDEbW0VJY3JoAewhyET/JlmJWTepBXv9MjsjzHq9/mCQCMoUNzWu0+
ufoNnjVDq8HGBKgcgCatx6CfzGdoNRrYxPmpHYAmncegn9xnaNXbmAClA9Ck8Rj0Y+Qm3IrU4doP
X44Py0akztW+KrINqSO1osFU8gT5IHJhyjQYVoRo1VpjaWvIGDszZRqMmph43fVaY2lnyBg7N2Ua
9CtCtHKtsbQxZIy9M+X5wwL1Eu7D5fj54fnh/HR8DF7Hlfp1nAXKp1LqxZyLogPExqUPQhdbaNoP
qQJBqyRK4zZNo+9sC037MVowcb7rJErjLk2j73wLTfs+VSBomURp3KRp9B3NdbglqvfOPvxy+Ykv
DNUbZ7MoG6N610zJcEfIFXEQovAI2gwWJHJlyjRobQJ9ZB5Bm3EFTZyP2pRp0NkE+sg9gja9BYlc
mjINGptAH6tchI9r6gTX33+6HB/U45o6vCWyPK6pc1sBgDEkQiFzEKbwGVoNNiZA5QA0aT0G/WQ+
Q6vRwCbOT+0ANOk8Bv3kPkOr3sYEKB2AJo3HoB8jN2G81E36Hw+n56fjVxyjztW9GboETN2SQwLD
SMJW0EGgIgLRbHA4ISqPoE3rQugpi0A0Gy1u4jzVHkGbzoXQUx6BaNY7nBClR9CmcSH0ZOXIOKB0
/dsV2euriL/++WP2n/789efj88f+fVPtgsM9L+S+ncnu8Xl4+HS9176wWV4VwQmWl5gWNjwbv1Mt
DFFWfF+msNj77BQ0XDQG+/5y+ldoPv/QZtXPBfJzj9frC9GXPqo7F13auL3LW5UL+vaDaoHl/Itu
VWFzi9/t5MvdMgW3X7W6XVK2nq0hn9Hxrh/e9bti/wYunrcfDxlaDeZtAM4/O9UuUyQ/fnTtc481
f7ue9s5Fl+Fv33kfimD4fRH0eTvlMpQhGF7Q7Y2doQrBJgDnKaoDsNkpcPnAY9iHYOk4NiFYBeDt
NXC1DI2vMIbhuL1urCqfXXxvT4533czKV3acjFxX6tJFeDrsRuu1WiZovVqLGB2u1yr36dzaDKos
URCOUHexAuMC6jZRoD6suLa0pGT+uCFoZX4Xv1pakfeSw73m9sZ21bpouO3u+1i/xfrvuY/OebGe
kX10znEnmF/HNNERyuCVzcsITXSEcv1XbaJ/1Wp9DU30r1qtR2ij11CvR2ij11AbI0SvYW+MEL2G
vR7h+mCZjW5B+XJbCM4k5/4VX+lVjvJdklftv/yxo3zYfd64/PVWHnbvLwP1BDIfJm05N7+aN7Xb
DagdPFLtBNcF3jg7Qfhclft/evMRKPf/8vZjUOXwzj3h2pIX31vJ+k96LbqLF6mLmY+4dZIbHH0K
J/92Tqu9j8DhbXi/zP8PD/9xH1dvn4cVS2CmT9cb5tPx9rfVf4Hbw0VxF6NX3p1Jmw+it5JqyeP8
0VF4a7h1Ug0OqD50uN75dgRP5v1m/gSjuvfZ8OLullm+/Yzg628GWdGaC9qgYHr+bODz2xf18ofB
K+fgZj2/lK/vfPat7/8DMhQB92lwAAA=

--=-uGRiBr9YRwlH0sXqO20t--


--__--__--

Message: 2
Date: Sun, 8 Dec 2002 10:15:40 -0500
From: "James K. Lowden" <jklowden AT schemamania.org>
To: freetds AT lists.ibiblio.org
Cc: freddyz77 AT tin.it
Subject: Re: [freetds] collate and TDS8
Reply-To: freetds AT lists.ibiblio.org

On 07 Dec 2002 18:26:40 +0100, Frediano Ziglio <freddyz77 AT tin.it> wrote:
> 
> > Mine 0xd0 -> 0000 0000 1101 0000 -> third: 1 width insensitive 1
> > katatype insensitive 0 accent sensitive 1 case insensitive
> > Yours 0x100 -> 0000 0001 0000 0000 -> second: 0 0 0 1 binary third
> > 0000 all insensitive.
> > Other bits ??
> > 
> 
> Last nibble of bytes 2-3 is language modifier. Last byte is id or 0
> Other bits confirmed, see also attachment (extracted from query I send
> in previous mail)
> 
> So now we know all bits of collation info. Problem is to use all info
> and how...

Frediano, 

Nice work!  Does this represent what we now know?

typedef struct 
{
        TDS_SMALLINT    locale_id;  /* master..syslanguages.lcid */
        TDS_UCHAR       unknown;
        TDS_UCHAR       sort_flags; /* high nybble only */
        TDS_UCHAR       charset_id; /* or zero */
} TDS8_COLLATION;

/* SF stands for "sort flag" */

#define TDS_SF_WIDTH_INSENSITIVE     (TDS_UCHAR) 0x80
#define TDS_SF_KATATYPE_INSENSITIVE  (TDS_UCHAR) 0x40
#define TDS_SF_ACCENT_SENSITIVE      (TDS_UCHAR) 0x20
#define TDS_SF_CASE_INSENSITIVE      (TDS_UCHAR) 0x10

--jkl


--__--__--

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest


The information transmitted is intended only for the person or entity to 
which it is addressed and may contain confidential or privileged material.  
Any review, distribution, or other unauthorized use of the information by 
persons or entities other than the intended recipient is prohibited.   If you 
received this communication in error, please contact the sender and delete 
the material from any computer.