Hello, Jester!
Thanks for giving me a possibility to test program on your
secure pages! Now we know the reason of this problem:
Big5 charset may have "bad" characters like slashes in multibyte
sequence of one Chinese sign. indexer doesn't escape words during
INSERTs into database, however it should, at least in the case of
Big5 as a LocalCharset. We'll fix it shortly.
Quick workaround while we are fixing the problem is to store
everything in UTF-8. Just use LocalCharset utf-8 in both
indexer.conf and search.htm, and use Big5 as BrowserCharset
in search.htm
It should work fine for you for these reasons:
- utf-8 has all Chinese characters introduced in Big5
so you will not loose any data during conversion.
- it doesn't have "bad" characters like slash ('\'), so
both MySQL and PostgreSQL will accept any Chinese sigh.
- using Big5 as a BrowserCharset will display results in your
prefered encoding
Regards!
> ----- Original Message -----
> From: "Alexander Barkov" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, November 28, 2001 2:04 AM
> Subject: Re: Bug #63 Updated: indexer[11978]: [1] Error: 'ERROR:
> Unterminated quoted string
>
>
>
>>Hello!
>>
>> indexer[29622]: [1] URL: http://dev.cns.org.hk/feature.php
>>
>>>indexer[29622]: [1] URL: http://dev.cns.org.hk/policy/pro_list.html
>>>indexer[29622]: [1] Error: '#1064: You have an error in your SQL syntax
>>>
> near
> '�T',32964864),(6,'��',33030400),(6,'��',33095936),(6,'��',33161472),(6,'��'
> ,3322' at line 1'
>
>>
--
bar
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
