Re: [Wikitech-l] how to convert the latin1 SQL dump back into UTF-8?
jida...@jidanni.org schrieb: > The BLOBs are fine, it's just the VARCHARs, > `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL > default '', > How can one convert these back to UTF-8 with a script, outside of mysql, just > for > occasional viewing of the SQL dumps outside of the wiki. > Yes, my wiki works fine. > OK, I'll study > http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html Again: never mind what it is declared as, it *is* UTF-8. MySQL may however automatically convert it on the way to the clinet or dump program. To prevent that, tell mysql that the encoding of your client is latin1. Confusing? Hell yea :) -- daniel ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] how to convert the latin1 SQL dump back into UTF-8?
The BLOBs are fine, it's just the VARCHARs, `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '', How can one convert these back to UTF-8 with a script, outside of mysql, just for occasional viewing of the SQL dumps outside of the wiki. Yes, my wiki works fine. OK, I'll study http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] [SPAM] Re: A proposal to de-table Wikipedia infoboxes
On Thu, Mar 5, 2009 at 5:48 PM, Michael Daly wrote: > I'd like to see the CSS/HTML that can do that without JS or something > else. I'm not familiar with a technique to implement dynamically > resizable columns in CSS/HTML. That's what column-* is for. Of course, IE doesn't support it (including IE8). I sketched a couple of other possibilities I could think of on the bug, with their limitations. Inline-blocks would probably be feasible. ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] [SPAM] Re: A proposal to de-table Wikipedia infoboxes
jida...@jidanni.org wrote: > Also maybe there can be a way to not use for page layout on > Special Pages, https://bugzilla.wikimedia.org/show_bug.cgi?id=17595 . In which bug you state: "With the obsolete hardwired tables design, one cannot browse: 1 2 3 4 5 6 7 8 or 1 2 3 4 5 6 or 1 2 3 4 " I'd like to see the CSS/HTML that can do that without JS or something else. I'm not familiar with a technique to implement dynamically resizable columns in CSS/HTML. Mike ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] A proposal to de-table Wikipedia infoboxes
Also maybe there can be a way to not use for page layout on Special Pages, https://bugzilla.wikimedia.org/show_bug.cgi?id=17595 . ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] Images with relative (percentage) dimensions?
Aryeh Gregor gmail.com> writes: > On Thu, Mar 5, 2009 at 7:07 AM, Yury Tarasievich ... > It would be possible, but it would look terrible for most users. > Browsers just don't do resizing that looks good, and the server > doesn't know about percentage widths. Therefore only exact pixel > sizes can feasibly be used in a lot of cases. For some cases, of > course, browser resizing might look good enough. That was my reason for asking. I understand the concern for quality, but I expect fair quality for some cases and for some percentages, however. So, about the modules/functions involved? -- ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] Images with relative (percentage) dimensions?
On Thu, Mar 5, 2009 at 7:07 AM, Yury Tarasievich wrote: > Would it be at all possible to implement sizing an image to the > percentage of its containing element (table, div)? Or would such a > functionality be impossible "by design"? It would be possible, but it would look terrible for most users. Browsers just don't do resizing that looks good, and the server doesn't know about percentage widths. Therefore only exact pixel sizes can feasibly be used in a lot of cases. For some cases, of course, browser resizing might look good enough. ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] Images with relative (percentage) dimensions?
I understand this might be old. Would it be at all possible to implement sizing an image to the percentage of its containing element (table, div)? Or would such a functionality be impossible "by design"? Alternatively, please point me to the code fragments which produce the Image: tags' markup for rendering in browsers. Thanks. ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Re: [Wikitech-l] how to convert the latin1 SQL dump back into UTF-8?
jida...@jidanni.org schrieb: > Say, e.g., api.php?action=query&list=logevents looks fine, but when I > look at the same table in an SQL dump, the Chinese utf8 is just a > latin1 jumble. How can I convert such strings back to utf8? I can't > find the place where MediaWiki converts them back and forth. It doesn't. it's already UTF8, only mysql things it's not. this is because mysql doesn't support utf8 before 5.0, and even in 5.0 and later, the support is flacky. So, mediawiki (per default) tells mysql that the data is latin1 and treates it as binary. If you see it asa "jumble" entirely depends on the program you view it with. this is a nasty hack, and it may cause corruption when importing/exporting dumps. be careful about it. -- daniel ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
[Wikitech-l] how to convert the latin1 SQL dump back into UTF-8?
Say, e.g., api.php?action=query&list=logevents looks fine, but when I look at the same table in an SQL dump, the Chinese utf8 is just a latin1 jumble. How can I convert such strings back to utf8? I can't find the place where MediaWiki converts them back and forth. You see I'm just curious, let's say all I had was the SQL dump, and GNU/Linux tools, but no MediaWiki. How can I get the original UTF-8 strings back out of the SQL dump? ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
