SMF 2.1.2 has been released! Take it for a spin! Read more.
Started by aswuser, June 24, 2022, 01:22:20 PM
Quote from: aswuser on June 24, 2022, 01:22:20 PMcron.php/home/mysite/public_html/forumnew//Sources/Subs.php (Line 529): Incorrect string value: '\xE0\xAE\x9A\xE0\xAE\xBF...' for column `school10_smf_forumnew`.`smf_settings`.`value` at row 1
Quote from: aswuser on June 24, 2022, 02:49:20 PMSo I should change latin1_swedish_ci to utf8_general_ci here? (screenshot).
Quote from: aswuser on June 24, 2022, 02:49:20 PMSorry if my questions seem dumb. Not used to doing changes in DB and it's scary!
Quote from: Doug Heffernan on June 24, 2022, 02:53:54 PMI understand your reluctance
Quote from: Illori on June 24, 2022, 04:40:54 PMthis is why you should always do a backup first. https://wiki.simplemachines.org/smf/Backup
Quote from: Doug Heffernan on June 24, 2022, 02:53:54 PMYes, you can change the collation charater for all tables and columns from the phpmyadmin, but make first a backup of your database though.
Quote from: Kindred on June 24, 2022, 06:34:18 PMMore specifically, you need to run a series of CONVERT routines... just changing it nay result in unexpected consequences
UPDATE smf_membersSET lngfile = CONCAT(lngfile, '-utf8')WHERE lngfile != ''