Author: oona Email: [EMAIL PROTECTED] Message: hi, thnanks for your reply , below are the output what I have done as you mentioned . I search "�W��"(Big5 code), but I saw the second statement select word='l', is this correct ?
Is that the word can be found must stored in the word column ? I didn't see any big5 code stored in the word column. I have set the Localcharset to "LocalCharset Big5". Another question, if want to support both big5 and gb2312 charset, is that correct I set both LocalCharset Big5 , LocalCharset gb2312 in the indexer.conf . ./search.cgi ��� 2>/dev/null [49678] SQL 0.01s: SELECT word,lang FROM stopword the word ��� and �W�� has stored in keywords column ./search.cgi �W�� 2 > /dev/null [50411] SQL 0.01s: SELECT word,lang FROM stopword [50411] SQL 0.01s: SELECT url_id,intag FROM dict WHERE word='w' [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod_time,title,txt,docsiz e,last_index_time,next_index_time,referrer,keywords,description,crc32,category ROM url WHERE rec_id IN (1200,1201,1154,1202,1210,1182,1179,1171,1159,1158) ORDE R BY rec_id [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=-695477907 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.01s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=-928061118 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=-868025101 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=1175629745 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.01s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=891337902 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod_time FROM url WHERE rc32=1695190869 AND (status=200 OR status=304 OR status=206) [50411] SQL 0.00s: SELECT rec_id,url,content_type,last_mod > > There are many possible reasons, mostly because of incorrect > indexer and search configuration: > Check that DBAddr, DBMode, LocalCharset are the same > in both indexer.conf and search.htm. Then, if nothing > helps, uncomment #define DEBUG_SQL in the top of sql.c, > recompile, and run search.cgi from command line: > > ./search.cgi foo > > where foo is a word you want to find. > > search.cgi will display all queries being sent > to SQL server. Reply: <http://www.mnogosearch.org/board/message.php?id=3924> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
