Difference between revisions of "User:Alvonruff/Test Pages"
Jump to navigation
Jump to search
(New page: ==Author== * 001 - http://www.isfdb2.org/cgi-bin/ea.cgi?183544 - Afrikaans * 002 - http://www.isfdb2.org/cgi-bin/ea.cgi?183544 - Albanian * 003 - http://www.isfdb2.org/cgi-bin/ea.cgi?32005...) |
(→Author) |
||
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | 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): | ||
+ | |||
+ | <pre> | ||
+ | try: | ||
+ | db = MySQLdb.connect(DBASEHOST, USERNAME, PASSWORD, conv=_IsfdbConvSetup()) | ||
+ | db.select_db(DBASE) | ||
+ | db.set_character_set("latin1") | ||
+ | SQLUpdateQueries() | ||
+ | </pre> | ||
+ | |||
+ | The test is to add the following characters at the end of a non-ASCII string, to the pages below: ßé | ||
+ | |||
+ | |||
==Author== | ==Author== | ||
− | * 001 - http://www.isfdb2.org/cgi-bin/ea.cgi?183544 - Afrikaans | + | * 001 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?183544 - Afrikaans |
− | * 002 - http://www.isfdb2.org/cgi-bin/ea.cgi? | + | * 002 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164138 - Albanian |
− | * 003 - http://www.isfdb2.org/cgi-bin/ea.cgi?320057 - Ancient Greek | + | * 003 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?320057 - Ancient Greek |
− | * 004 - http://www.isfdb2.org/cgi-bin/ea.cgi?275060 - Arabic | + | * 004 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?275060 - Arabic |
− | * 005 - http://www.isfdb2.org/cgi-bin/ea.cgi?164109 - Armenian | + | * 005 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164109 - Armenian |
− | * 006 - http://www.isfdb2.org/cgi-bin/ea.cgi? | + | * 006 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?248284 - Azerbaijani |
− | * 007 - http://www.isfdb2.org/cgi-bin/ea.cgi?164221 - Basque | + | * 007 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164221 - Basque |
− | * 008 - http://www.isfdb2.org/cgi-bin/ea.cgi?339708 - Belarusian | + | * 008 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?339708 - Belarusian |
− | * 009 - http://www.isfdb2.org/cgi-bin/ea.cgi?329491 - Bengali | + | * 009 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?329491 - Bengali |
− | * 010 - http://www.isfdb2.org/cgi-bin/ea.cgi?335553 - Bulgarian | + | * 010 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?335553 - Bulgarian |
− | * 011 - http://www.isfdb2.org/cgi-bin/ea.cgi?164220 - Burmese | + | * 011 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?164220 - Burmese |
− | * 012 - http://www.isfdb2.org/cgi-bin/ea.cgi?266636 - Catalan | + | * 012 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?266636 - Catalan |
− | * 013 - http://www.isfdb2.org/cgi-bin/ea.cgi?344566 - Chinese | + | * 013 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?344566 - Chinese |
− | * 014 - http://www.isfdb2.org/cgi-bin/ea.cgi? | + | * 014 - ???? - http://www.isfdb2.org/cgi-bin/ea.cgi?xxxxxx - Czech |
− | * 015 - | + | * 015 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?304036 - Danish |
− | * 016 - | + | * 016 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?344718 - Dutch |
− | * 017 - | + | * 017 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?26 - English |
− | * 018 - | + | * 018 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?213970 - Esperanto |
− | * 019 - | + | * 019 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?157961 - Estonian |
− | * 020 - | + | * 020 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?197008 - Filipino |
− | * 021 - | + | * 021 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?276496 - Finnish |
− | * 022 - | + | * 022 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?342790 - French |
− | * 023 - | + | * 023 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?177812 - Frisian |
− | * 024 - | + | * 024 - PASS - http://www.isfdb2.org/cgi-bin/ea.cgi?194710 - Galician |
− | * 025 - | + | * 025 - http://www.isfdb2.org/cgi-bin/ea.cgi?291087 - Georgian |
− | * 026 - | + | * 026 - http://www.isfdb2.org/cgi-bin/ea.cgi?344747 - German |
− | * 027 - | + | * 027 - http://www.isfdb2.org/cgi-bin/ea.cgi?298581 - Greek |
* 028 - NONE | * 028 - NONE | ||
− | * 029 - | + | * 029 - http://www.isfdb2.org/cgi-bin/ea.cgi?336435 - Hebrew |
− | * 030 - | + | * 030 - http://www.isfdb2.org/cgi-bin/ea.cgi?294992 - Hindi |
− | * 031 - | + | * 031 - http://www.isfdb2.org/cgi-bin/ea.cgi?298821 - Croatian |
− | * 032 - | + | * 032 - http://www.isfdb2.org/cgi-bin/ea.cgi?338080 - Hungarian |
* 033 - | * 033 - | ||
* 034 - | * 034 - | ||
Line 49: | Line 62: | ||
* 048 - | * 048 - | ||
* 049 - | * 049 - | ||
+ | * select * from authors where author_language='xx'; | ||
* 050 - | * 050 - | ||
* 051 - | * 051 - |
Latest revision as of 12:04, 7 May 2022
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]]