[freetds] Re: hex(92), freeTDS and MS SQL

Adam Prime x443 aprime at brunico.com
Wed Oct 27 17:08:29 EDT 2004


well, i changed the conf to says window-1252 and restarted apache.  conf looks like this:

[clients]
        host = 10.10.10.20
        port = 1433
        tds version = 7.0
        client charset = windows-1252
        text size = 512000
        dump file = /tmp/freetds.log
        debug level = 99

the log says this on connection:

2004-10-27 17:04:49 inside tds_process_login_tokens()
Received packet @ 2004-10-27 17:04:49
0000  e3 1b 00 01 06 6d 00 61 00 73 00 74 00 65 00 72   |ã....m.a.s.t.e.r|
0010  00 06 6d 00 61 00 73 00 74 00 65 00 72 00 ab 6a   |..m.a.s.t.e.r.«j|
0020  00 45 16 00 00 02 00 25 00 43 00 68 00 61 00 6e   |.E.....%.C.h.a.n|
0030  00 67 00 65 00 64 00 20 00 64 00 61 00 74 00 61   |.g.e.d. .d.a.t.a|
0040  00 62 00 61 00 73 00 65 00 20 00 63 00 6f 00 6e   |.b.a.s.e. .c.o.n|
0050  00 74 00 65 00 78 00 74 00 20 00 74 00 6f 00 20   |.t.e.x.t. .t.o. |
0060  00 27 00 6d 00 61 00 73 00 74 00 65 00 72 00 27   |.'.m.a.s.t.e.r.'|
0070  00 2e 00 0a 43 00 4c 00 49 00 45 00 4e 00 54 00   |....C.L.I.E.N.T.|
0080  53 00 44 00 45 00 56 00 00 00 00 e3 17 00 02 0a   |S.D.E.V....ã....|
0090  75 00 73 00 5f 00 65 00 6e 00 67 00 6c 00 69 00   |u.s._.e.n.g.l.i.|
00a0  73 00 68 00 00 ab 6e 00 47 16 00 00 01 00 27 00   |s.h..«n.G.....'.|
00b0  43 00 68 00 61 00 6e 00 67 00 65 00 64 00 20 00   |C.h.a.n.g.e.d. .|
00c0  6c 00 61 00 6e 00 67 00 75 00 61 00 67 00 65 00   |l.a.n.g.u.a.g.e.|
00d0  20 00 73 00 65 00 74 00 74 00 69 00 6e 00 67 00   | .s.e.t.t.i.n.g.|
00e0  20 00 74 00 6f 00 20 00 75 00 73 00 5f 00 65 00   | .t.o. .u.s._.e.|
00f0  6e 00 67 00 6c 00 69 00 73 00 68 00 2e 00 0a 43   |n.g.l.i.s.h....C|
0100  00 4c 00 49 00 45 00 4e 00 54 00 53 00 44 00 45   |.L.I.E.N.T.S.D.E|
0110  00 56 00 00 00 00 e3 0f 00 03 05 69 00 73 00 6f   |.V....ã....i.s.o|
0120  00 5f 00 31 00 01 00 00 e3 0b 00 05 04 31 00 30   |._.1....ã....1.0|
0130  00 33 00 33 00 00 e3 0f 00 06 06 31 00 39 00 36   |.3.3..ã....1.9.6|
0140  00 36 00 30 00 39 00 00 ad 36 00 01 07 00 00 00   |.6.0.9..­6......|
0150  16 4d 00 69 00 63 00 72 00 6f 00 73 00 6f 00 66   |.M.i.c.r.o.s.o.f|
0160  00 74 00 20 00 53 00 51 00 4c 00 20 00 53 00 65   |.t. .S.Q.L. .S.e|
0170  00 72 00 76 00 65 00 72 00 00 00 00 00 08 00 02   |.r.v.e.r........|
0180  f8 e3 13 00 04 04 34 00 30 00 39 00 36 00 04 34   |øã....4.0.9.6..4|
0190  00 30 00 39 00 36 00 fd 00 00 00 00 00 00 00 00   |.0.9.6.ý........|

Which still says iso_1, which doesn't have the silly quotes.  i tried using CP1252, which iconv -all lists, but DB connections don't work with client charset set to that.

Thanks for the tip about the logging, i haven't ever had a need for it before.



-----Original Message-----
From: Daniel Fazekas [mailto:fdsubs at axelero.hu]

On Oct 27, 2004, at 21:47, Adam Prime x443 wrote:

>  however, when someone pastes a "smart-quoted" quotation mark from 
> word (hex92) into a field to put it into the database, it gets changed 
> into a question mark (hex63).

Try changing your client charset setting in freetds.conf to 
windows-1252.

iso-8859-1 doesn't contain the "smart quotes."

> According to snort,

Alternatively, try enabling freetds' own logging facilities. I'm sure 
you'll find it more useful.

--
fds

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



More information about the FreeTDS mailing list