Trying to insert a post with long word with Cyrillic characters ("Константинович") totally breaks search index insert:
Sorry! The page could not be loaded.
This is probably a temporary error. Just refresh the page and retry. If problem continues, please check back in 5-10 minutes.
Database reported: ERROR: value too long for type character varying(20) .
Failed query: INSERT INTO search_words (word) VALUES('константинович')
The error occurred on line 151 in /home/forums/htdocs/include/search_idx.php
From my POV, that's a shooting offense for a programmer who thought that "20 bytes would be enough for everybody". Also, it's probably a sign of screwed up SQL scheme, i.e. missing encodings.