This isn't so much a help question as it is a what makes it tick question. Have been following the Help forum Table 'pgv_site_setting already exists thread.
Out of curiosity because I couldn't remember what I did on the new install I did I checked my PGV database. The tables and default collation are utf8_unicode_ci. When I click the structure tab in phpmyadmin I see that some of the is it rows within the tables? are latin1_swedish_ci. There's no mix/match in those rows, if there's a collation it's just latin1_swedish_ci.
Since everything is working I'm not going to fix it but is this difference any sort of issue?
It might be working OK simply because your GEDCOM file is not big enough to be slowed down by those mixed collations. That is often the only impact. It is especially obvious when using the Search features.
I would recommend fixing the fields that are not consistent now rather than wait for a problem to appear. Its easily done manually in phpmyadmin if there's only a few.
I saw I can change the collation, just didn't want to break anything that seems to be working. Especially without mentioning something first! I'll change it tomorrow nite.
If you "just change it", using phpMyAdmin, you will probably corrupt all your non-ascii characters (accented letters, greek/cyrillic/hebrew/arabic text, etc.)
A brief explanation of why is here: https://sourceforge.net/tracker/?func=detail&aid=2318005&group_id=55456&atid=477081
Ah good thing I didn't get into any hurry on this . . . excellent explanation Greg, thanks.
The conversion went well, thanks much, all working well.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.