User:Alvonruff/Test Pages

Test results based on a fresh build, with the inclusion of the following line of code in SQLparsing.py, just after dn.select_db(DBASE):

try:
        db = MySQLdb.connect(DBASEHOST, USERNAME, PASSWORD, conv=_IsfdbConvSetup())
        db.select_db(DBASE)
        db.set_character_set("latin1")
        SQLUpdateQueries()

The test is to add the following characters at the end of a non-ASCII string, to the pages below: ßé

Author

• 001 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?183544 - Afrikaans
• 002 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164138 - Albanian
• 003 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?320057 - Ancient Greek
• 004 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?275060 - Arabic
• 005 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164109 - Armenian
• 006 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?248284 - Azerbaijani
• 007 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164221 - Basque
• 008 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?339708 - Belarusian
• 009 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?329491 - Bengali
• 010 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?335553 - Bulgarian
• 011 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164220 - Burmese
• 012 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?266636 - Catalan
• 013 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?344566 - Chinese
• 014 - ???? - http://www.isfdb2.org/cgi-bin/ea.cgi?xxxxxx - Czech
• 015 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?304036 - Danish
• 016 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?344718 - Dutch
• 017 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?26 - English
• 018 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?213970 - Esperanto
• 019 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?157961 - Estonian
• 020 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?197008 - Filipino
• 021 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?276496 - Finnish
• 022 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?342790 - French
• 023 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?177812 - Frisian
• 024 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?194710 - Galician
• 025 - http://www.isfdb2.org/cgi-bin/ea.cgi?291087 - Georgian
• 026 - http://www.isfdb2.org/cgi-bin/ea.cgi?344747 - German
• 027 - http://www.isfdb2.org/cgi-bin/ea.cgi?298581 - Greek
• 028 - NONE
• 029 - http://www.isfdb2.org/cgi-bin/ea.cgi?336435 - Hebrew
• 030 - http://www.isfdb2.org/cgi-bin/ea.cgi?294992 - Hindi
• 031 - http://www.isfdb2.org/cgi-bin/ea.cgi?298821 - Croatian
• 032 - http://www.isfdb2.org/cgi-bin/ea.cgi?338080 - Hungarian
• 033 -
• 034 -
• 035 -
• 036 -
• 037 -
• 038 -
• 039 -
• 040 -
• 041 -
• 042 -
• 043 -
• 044 -
• 045 -
• 046 -
• 047 -
• 048 -
• 049 -
• select * from authors where author_language='xx';
• 050 -
• 051 -
• 052 -
• 053 -
• 054 -
• 055 -
• 056 -
• 057 -
• 058 -
• 059 -
• 060 -
• 061 -
• 062 -
• 064 -
• 065 -
• 066 -
• 067 -
• 068 -
• 069 -
• 070 -
• 071 -
• 072 -
• 073 -
• 074 -
• 075 -
• 076 -
• 077 -
• 078 - None
• 079 -
• 080 -
• 081 -
• 082 -
• 083 -
• 084 -
• 085 -
• 086 - None
• 087 -
• 088 -
• 089 -
• 090 -
• 091 -
• 092 -
• 093 -
• 094 -
• 095 -
• 096 -
• 097 -
• 098 -
• 099 - None
• 100 -
• 101 -
• 102 -
• 103 -
• 104 -
• 105 -
• 106 - None
• 107 -
• 108 -
• 109 -
• 110 -
• 111 - None
• 112 -
• 113 -
• 114 - None
• 115 -
• 116 - None
• 117 - None
• 118 - None
• 119 - None
• 120 - None
• 121 - None
• 122 - None
• 123 -
• 124 - None
• 125 -
• 142 -
• 149 -
• 151 -

• select * from authors where author_language='xx';

Title

• [[1]]