User:Alvonruff/Test Pages
Jump to navigation
Jump to search
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]]