[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #7 from Bugzilla Bug Importer (valhallasw) --- This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: guanda...@nurfuerspam.de CC list: guanda...@nurfuerspam.de, wikimedia-bugzi...@dabpunkt.eu -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Guandalug Date: Fri, 25 Jun 2010 23:36:30 --- Compressed XML result file of the forementioned query -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Guandalug Date: Fri, 25 Jun 2010 23:37:33 --- Query done -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- --- From: DaB. Date: Sat, 26 Jun 2010 12:00:14 --- @Guadalug "--default-character-set=UTF8" is wrong, the data is stored as latin1 (but it is in reality utf8). Remove that and check the charset of your terminal, if you get garbish. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Guandalug Date: Fri, 25 Jun 2010 23:35:39 --- Run query: mysql -X -h commonswiki-p.db.toolserver.org -D commonswiki_p --default-character-set=UTF8 -n --delimiter=';' -e "select img_name,img_minor_mime from image where lower(img_name) like '%.svg';" | tee SVGList.xml There's most likely a better way doing it, but this ought to work. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Leo k Date: Sat, 26 Jun 2010 11:38:45 --- Did you maybe double-encode the data? I tried opening as UTF8, UTF16, Latin1 and a few others & I always get the nonstandard chars garbled -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59346] DBQ-94 Find all SVG Images on commons
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346 --- Comment #6 from Bugzilla Bug Importer (valhallasw) --- --- From: Guandalug Date: Sat, 26 Jun 2010 13:52:00 --- New attempt. CSV this time, Characters seem to be intact as far as my UTF8-capable editor can be trusted. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l