Individual List

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z | (unknown) | ALL

Show Surname lists

ERROR:-1 DB Error: unknown error
SQL:
SELECT i_id, i_gedcom, i_name, i_letter,i_surname, i_isdead FROM pgv_individuals WHERE (i_letter LIKE 'C%' OR i_letter = 'Ç' OR i_letter = 'Ć' OR i_letter = 'Ĉ' OR i_letter = 'Ċ' OR i_letter = 'Č') AND i_file=1 ORDER BY i_name [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']


ERROR:-1 DB Error: unknown error
SQL:
SELECT i_id, i_name, i_file, i_isdead, i_gedcom, i_letter, i_surname, n_letter, n_name, n_surname, n_letter, n_type FROM pgv_individuals, pgv_names WHERE i_id=n_gid AND i_file=n_file AND (n_letter LIKE 'C%' OR n_letter = 'Ç' OR n_letter = 'Ć' OR n_letter = 'Ĉ' OR n_letter = 'Ċ' OR n_letter = 'Č')AND n_type!='C' AND i_file=1 ORDER BY i_name [nativecode=1267 ** Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=']