MySQL & Latin1 woes … E4X … Pirahã … Alcabala 22nd of June, 2007 POST·MERIDIEM 10:53
Okay, for that eager plethora heh of my readers who have heavily used non-ASCII UTF-8, who stored that UTF-8 with metadata saying that it was latin 1 in a MySQL 4.1.11 database, and who need to move to a MySQL 5.0.41 where such thoughtless trust of the program not to corrupt your data no longer works, I have enlightenment on how to do that migration.
mysqldump -u user-name --password=password --default-character-set=latin1 database-name
utf8everywhere that’s not in your data.
and give the password for the database server (which you have configured, right? Right?).
mysql -u user -p database-name-not-password,-sorry-to-confuse-you < modified-dump-file-name
ECMAScript for XML is the unwieldy name of a recent standard for processing XML data
impressed. For me, the initial stumbling blocks were the namespaces and
xmlns; but a
and a subsequent addressing of all elements (attributes, etc) with
var jdfns = new Namespace("http://www.CIP4.org/JDFSchema_1");
And thirdly, in energetic contrast to Emma and Simon’s take on it, I found this New Yorker article on Daniel Everett’s work with the Pirahã really, really good. It’s a magazine article, and as such it doesn’t try to treat the linguistics in detail, any more than the recent article on Григорий Перельман treated the mathematics of the Poincaré conjecture, but it deals well with communicating the sociology of the disagreements the Pirahã provoke; it quotes Michael Tomasello in a critical but diplomatic tone, and gives a vivid picture of the occasional hellishness of tropical field work.
The impression I get from it (and it is to my discredit that I hadn’t read
the relevant papers already, but in my defense they were on
lingbuzz, which to anyone not interested in generativism is as
interesting as the theological debates of the 7th Day Adventists) is of the
Pirahã as the apogee of anti-intellectualism; when other language
communities have had number systems that lacked in the fine differentiation
of most western languages, they were happy to pick them up, but for the
Pirahã the difference seems to have been a social pressure not to.
Word of the day: قبالة qabālat (v.n. of قبل), in Persian qabāla, qubāla: surety, contract (especially of bargain and sale); in Spanish as la alcabala, an historical sales tax; in Hebrew as kabala קבלה, meaning invoice/receipt.
/usr/ports/databases/php5-dba/work/php-5.2.3/ext/dba/.libs/dba_db4.oexists, and that I’m getting errors in PHP when I try to use the DB4 handler in dbm_open :-/ . Have you installed that port, or was the install_db4 option not turned on?
Some HTML is allowed. Use Preview if you’re not sure that what you type will be.