-
Bug
-
Resolution: Duplicate
-
Normal
-
None
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.
- duplicates
-
OTHER-130 Forums database encoding is incorrect/mismatched with PHP settings, preventing some valid posts
- Closed