Author: oona
Email: [EMAIL PROTECTED]
Message:
hi,
thnanks for your reply , below are the output what I have
done as you mentioned . I search "�L"(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=3906>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
