Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Adam Prime x443" <aprime AT brunico.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Re: hex(92), freeTDS and MS SQL
  • Date: Wed, 27 Oct 2004 17:08:29 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page