- Joined
- Aug 21, 1995
- Messages
- 5,764
Surprisingly there is.jeffy777 said:It's not like the standards for MySQL queries have changed that much from 4.0 to 4.1 (actually 5 is the latest version). I don't think the problem is that phpBB2 is outdated since it's constantly being updated all the time.
For starters, from 4.0->4.1, MySQL forces the connecting host (in this case php/phpbb) to read data in UTF-8 mode. However, PhpBB was designed and only likes data in Latin1(latin1_swedish_ci). PhpBB has been only updated in the past year or so for security exploits- not compatibility for MySQL.
PHP and Apache are both moving towards UTF-8 as the default character set, which wrecks havock on older scripts, which is the issue we have been fighting over the past couple days.