Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:13512
Return-Path: <jason@javasense.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 13329 invoked by uid 1010); 25 Oct 2004 17:45:43 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 9560 invoked by uid 1007); 25 Oct 2004 17:44:46 -0000
Message-ID: <20041025174445.9557.qmail@pb1.pair.com>
To: internals@lists.php.net
Date: Mon, 25 Oct 2004 11:44:30 -0600
Lines: 52
Organization: Javasense
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Posted-By: 63.230.14.90
Subject: [PATCH][PHP_5_0] MSSQL Uniqueid formatting, etc...
From: jason@javasense.com ("Jason Borden")

Here's a patch to the MSSQL extention that:

1. Formats a resultant uniqueidentifer into a string (instead of raw binary)
which is the same way that odbc handles them.

2. Enables uniqueids to be used from freetds if SYBUNIQUE is defined in the
freetds code. I believe this is what the original author intended to do,
since the current code doesn't do anything unless you add your own -D
compile definition or change the code to work.

This patch could probably also be applied to the 4.3 and 5.1 trees without
modification, I haven't tried.

Jason



begin 666 mssql-uniqueid-patch.diff
M9&EF9B M3G)U('!H<"US<F,O97AT+VUS<W%L+W!H<%]M<W-Q;"YC('!H<"US
M<F,M:F(O97AT+VUS<W%L+W!H<%]M<W-Q;"YC"BTM+2!P:' M<W)C+V5X="]M
M<W-Q;"]P:'!?;7-S<6PN8PDR,# T+3$P+3(U(#$Y.C(X.C0R+C<P-3(X.3@W
M,B M,#8P, HK*RL@<&AP+7-R8RUJ8B]E>'0O;7-S<6PO<&AP7VUS<W%L+F,)
M,C P-"TQ,"TR-2 Q.3HS-3HU-2XU,C8T.3$P-#@@+3 V,# *0$ @+3@Q-"PQ
M," K.#$T+#$T($! "B )"0EB<F5A:SL*("-I9F1E9B!344Q53DE1544*( D)
M8V%S92!344Q53DE1544Z('L*+0D)"6-H87(@*F1A=&$@/2!C:&%R8V]L*&]F
M9G-E="D["BL)"0EU;G-I9VYE9"!C:&%R("ID871A(#T@*'5N<VEG;F5D(&-H
M87(J*2!C:&%R8V]L*&]F9G-E="D["BL)"0EC:&%R("IR97-?8G5F.PHK"0D)
M:6YT(')E<U]L96YG=&@@/2 S-CL*( HM"0D)+RH@=6YI<75E:61E;G1I9FEE
M<B!I<R!A(#$V+6)Y=&4@8FEN87)Y(&YU;6)E<B J+PHM"0D)6E9!3%]35%))
M3D=,*')E<W5L="P@9&%T82P@,38L(#$I.PHK"0D)<F5S7V)U9B ](&5M86QL
M;V,H<F5S7VQE;F=T:"LQ*3L**PD)"7-P<FEN=&8H<F5S7V)U9BP@(B4P,E@E
M,#)8)3 R6"4P,E@M)3 R6"4P,E@M)3 R6"4P,E@M)3 R6"4P,E@M)3 R6"4P
M,E@E,#)8)3 R6"4P,E@E,#)8(BP@9&%T85LS72P@9&%T85LR72P@9&%T85LQ
M72P@9&%T85LP72P@9&%T85LU72P@9&%T85LT72P@9&%T85LW72P@9&%T85LV
M72P@9&%T85LX72P@9&%T85LY72P@9&%T85LQ,%TL(&1A=&%;,3%=+"!D871A
M6S$R72P@9&%T85LQ,UTL(&1A=&%;,31=+"!D871A6S$U72D["BL**PD)"5I6
M04Q?4U1224Y'3"AR97-U;'0L(')E<U]B=68L(')E<U]L96YG=&@L(# I.PH@
M"0D)?0H@"0D)8G)E86L["B C96YD:68*9&EF9B M3G)U('!H<"US<F,O97AT
M+VUS<W%L+W!H<%]M<W-Q;"YH('!H<"US<F,M:F(O97AT+VUS<W%L+W!H<%]M
M<W-Q;"YH"BTM+2!P:' M<W)C+V5X="]M<W-Q;"]P:'!?;7-S<6PN: DR,# T
M+3$P+3(U(#$Y.C(X.C0R+C<P-S(X.34V." M,#8P, HK*RL@<&AP+7-R8RUJ
M8B]E>'0O;7-S<6PO<&AP7VUS<W%L+F@),C P-"TQ,"TR-2 Q.3HS-CHR-2XU
M.#(Y,C$W-S8@+3 V,# *0$ @+38P+#<@*S8P+#<@0$ *("-D969I;F4@4U%,
M24U!1T4@4UE"24U!1T4*("-D969I;F4@4U%,0DE.05)9(%-90D))3D%260H@
M(V1E9FEN92!344Q605)"24Y!4ED@4UE"5D%20DE.05)9"BTC:69D968@4U%,
M54Y)455%("\J($9R96544T0@,"XV,2L@*B\**R-I9F1E9B!364)53DE1544@
M+RH@1G)E95131" P+C8Q*R J+PH@(V1E9FEN92!344Q53DE1544@4UE"54Y)
M455%"B C96YD:68*("-D969I;F4@1$)%4E)(04Y$3$4H82P@8BD@9&)E<G)H
)86YD;&4H8BD*
`
end