AL8 Forum
   登錄註冊幫助


標題: [D5.5] 只可搜索英文,中文不能,急求解決方法!
 L0vingJ
 0093152
Rank: 2Rank: 2

頭銜: Member

帖子: 90

精華: 0

積分: 1470 點

現金: 100 元

存款: 0 元

閱讀權限: 15

註冊: 2007-12-19

狀態: 離線
 
發表於 2008-9-12 08:28  資料  個人空間  短消息  加為好友 
只可搜索英文,中文不能,急求解決方法!

搜索功能只可搜索英文,即關鍵字或用戶名是輸入英文就可以搜索。

但如果是輸入中文,則會出現以下Error...

請問有沒有人知道解決方法?

問題纏繞已久,急求解決方法,請高手發言相助,感恩!

QUOTE:
Discuz! info: MySQL Query Error

User: JK.b
Time: 2008-9-12 8:27am
Script: /search.php

SQL: SELECT searchid, dateline,
('15'<>'0' AND uid='1' AND 1221179238-dateline<15) AS flood,
(searchstring='title|初音|0||\'75\',\'77\',\'83\',\'79\',\'78\',\'62\',\'63\',\'114\',\'64\',\'65\',\'66\',\'67\',\'69\',\'68\',\'70\',\'72\',\'90\',\'46\',\'49\',\'47\',\'50\',\'43\',\'104\',\'53\',\'54\',\'56\',\'57\',\'55\',\'58\',\'59\',\'60\',\'112\',\'111\',\'110\',\'34\',\'35\',\'113\',\'28\',\'96\',\'106\',\'94\',\'108\',\'105\',\'32\',\'33\',\'37\',\'3\',\'4\',\'5\',\'6\',\'81\',\'7\',\'91\'|0|0|all' AND expiration>'1221179238') AS indexvalid
FROM [Table]searchindex
WHERE ('15'<>'0' AND uid='1' AND 1221179238-dateline<15) OR (searchstring='title|初音|0||\'75\',\'77\',\'83\',\'79\',\'78\',\'62\',\'63\',\'114\',\'64\',\'65\',\'66\',\'67\',\'69\',\'68\',\'70\',\'72\',\'90\',\'46\',\'49\',\'47\',\'50\',\'43\',\'104\',\'53\',\'54\',\'56\',\'57\',\'55\',\'58\',\'59\',\'60\',\'112\',\'111\',\'110\',\'34\',\'35\',\'113\',\'28\',\'96\',\'106\',\'94\',\'108\',\'105\',\'32\',\'33\',\'37\',\'3\',\'4\',\'5\',\'6\',\'81\',\'7\',\'91\'|0|0|all' AND expiration>'1221179238')
ORDER BY flood
Error: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267




 AL8 Forum © All rights reserved.
頂部

聯繫我們 - AL8 Forum - 網頁空間由 I-SERVICES 提供 - Archiver - WAP
清除 Cookies, 當前時區 GMT+8, 現在時間是 2008-12-2 09:13
Processed in 0.016346 second(s), 7 queries , Gzip enabled
Powered by Discuz! 5.5.0  © 2001-2007 Comsenz Inc.