With earlier version of pgv I had not this problem. In the alphabetical list of family names it has other letters (see attachments).
family name with letter A
family name with letter E
family name with letter O
family name with letter R
family name with letter S
family name with letter U
Since your site is online, it would have been easier to post the URL (http://www.verwandten.info/pgv/indilist.php) than to post screen dumps.
It is also easier to examine problems when you have access to the site.
I guess you have some sort of collation issues. When I switch the site to English, I would expect to see just "O", not separate lists for "O" and "Ö".
Perhaps you have a mix of latin and utf8 encodings?
I checked the collation again and found "latin2_general_ci" at "site_setting_value". All other has the collation "utf8_unicode_ci". Now all has the collation "utf8_unicode_ci", but I get no correct result with the list of family names. The following letters includes also other family names: C, D, E, G, I, O, R, S and U.
You didn't say what collations you checked. You need to consider the full end-to-end communicaiton between client and server, not just the column properties.
I guess that dispite the settings, your data is a mixture of different physical encodings.
I checked the row statistik and the fields. All has the collate utf8_general_ci. The list of family names are still mixed. Yesterday I did import from a new GEDCOM file (UTF8). Now are in the list "A" also this family names: ÖCHSNER, ÖHE, ÖLZ, von ÖSTEREICH-TOSKANA, ÖSTERLE, von ÖSTERREICH, von ÖSTERREICH-UNGARN, ÖZGUVEN, ÜBERBACHER. In "C" it has this family names: von ASCHAU, ASCHWANDEN, ASHMAN, ASPERGER, ASSAUER, ASSENHEIMER, ASSMANN.
Greg, I experienced the same problem in an newly created instance. I found that utf8_unicode_ci seem to be the cause of the problem. Using utf8_general_ci in my old database all works fine. Is there a reason why utf8_unicode_ci is used instead of utf8_general_ci?
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.