| Author |
Message |
|
Joined: August 30, 2008
Posts: 3058
Submissions: 20
Location: Burlington, ON, Canada
|
| Weird Symbols (UTF8 Encoding) |
|
| Posted on Fri Jun 10, 2016 4:48 am |
Link to Post:  |
|
Hey Folks,
Database got upgraded by the host... Mucked some character encoding up due to the age of our database structure.
I've put a fix in place, so any weird symbols you may have noticed over the last ~24 Hours should have disappeared...
Let me know if anyone sees any side effects.
|
|
|
Joined: June 20, 2012
Posts: 325
Submissions: 22
Location: France
|
|
|
| Posted on Fri Jun 10, 2016 12:07 pm |
Link to Post: |
|
Testing for the sake of testing:
éèêë?
ÉÈÊË?
????? |
|
|
Joined: June 20, 2012
Posts: 325
Submissions: 22
Location: France
|
|
|
| Posted on Fri Jun 10, 2016 12:07 pm |
Link to Post: |
|
While posting the above post, I got this error message:
| Quote: |
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 240526, word_id, 0 FROM search_wordlist WHERE word_text IN ('testing', 'sake', 'xxxxx', 'xxxxx', 'xxxxx')
Line : 251
File : functions_search.php
|
xxxxx are the three test lines, displayed correctly in the message.
1st: 'e' lower case with acute, grave, circumflex, ulmaut, macron accents.
2nd: 'E' upper case with acute, grave, circumflex, ulmaut, macron accents.
3rd: a i u e o in japanese |
|
|
Joined: August 30, 2008
Posts: 3058
Submissions: 20
Location: Burlington, ON, Canada
|
|
|
| Posted on Fri Jun 10, 2016 7:37 pm |
Link to Post: |
|
| Shirluban wrote: | While posting the above post, I got this error message:
| Quote: |
Could not insert new word matches
DEBUG MODE
SQL Error : 1271 Illegal mix of collations for operation ' IN '
INSERT INTO search_wordmatch (post_id, word_id, title_match) SELECT 240526, word_id, 0 FROM search_wordlist WHERE word_text IN ('testing', 'sake', 'xxxxx', 'xxxxx', 'xxxxx')
Line : 251
File : functions_search.php
|
xxxxx are the three test lines, displayed correctly in the message.
1st: 'e' lower case with acute, grave, circumflex, ulmaut, macron accents.
2nd: 'E' upper case with acute, grave, circumflex, ulmaut, macron accents.
3rd: a i u e o in japanese |
Fix one, another breaks...
I'll dig into it, and see if it left a trace in the error log.
The version of phpBB that this site uses is become more "problem patch" than "phpBB code"... -_-
|
|
|
