#2686 I've the same problem with list of family names

v4.2.2
open
nobody
None
5
2009-10-05
2009-10-05
Otmar
No

With earlier version of pgv I had not this problem. In the alphabetical list of family names it has other letters (see attachments).

Otmar

Discussion

  • Otmar

    Otmar - 2009-10-05

    family name with letter A

     
  • Otmar

    Otmar - 2009-10-05

    family name with letter E

     
  • Otmar

    Otmar - 2009-10-05
     
  • Otmar

    Otmar - 2009-10-05

    family name with letter O

     
  • Otmar

    Otmar - 2009-10-05

    family name with letter R

     
  • Otmar

    Otmar - 2009-10-05

    family name with letter S

     
  • Otmar

    Otmar - 2009-10-05

    family name with letter U

     
  • Greg Roach

    Greg Roach - 2009-10-05

    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?

     
  • Otmar

    Otmar - 2009-10-05

    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.

    Otmar

     
  • Greg Roach

    Greg Roach - 2009-10-13

    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.

     
  • Otmar

    Otmar - 2009-10-15

    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.

    Otmar

     
  • Veit

    Veit - 2009-11-28

    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.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks