Archive for March, 2009

Code posting plugin for wordpress users

Posted by Linmic in 分享 on March 23rd, 2009

任何有 blogging 的程式設計者，除了相當有興趣/耐心的人會自己寫一套 code posting interface 之外，我想大部分的人都是想要找一個好得 plugin 可以把自己的心得漂漂亮亮的 share 給讀者吧。由於自己是 WordPress 的使用者，所以我想推薦 Code snippet 這個 plugin。

其實 code 的 highlight / 顏色，順不順眼就端看個人爽快( 自己是蠻滿意他本來的設定的 )，要改也可以自己去微調( 或是大調整 )。不過他支援相當多種語言的呈現，這點倒是替我省了不少功夫。

範例如下：

[code lang="php"]
<?php
echo “Hello world!’;
?>
[/code]

會變成以下的狀態呈現：

<?php

// This shall print the hello world text  

echo "Hello world!";

?>

算是相當好用呢！

code, wordpress

4 Comments

Javascript Debugging

Posted by Linmic in Javascript, 程式設計 on March 23rd, 2009

Gugod 大的方法，相當之聰明阿。Memo 一下：

If you are using IE and/or do not have a good debugger or console.log-ish style of tool, here’s some other quick and good alternatives to alert():

windows.status = message;

location.hash = message;

jQuery("input[type='text']").val(message);

They are better because they are all non-blocking statements.

Ref from: Gugod’s blog

alert, debug, Javascript

No Comments

Palm Pre

Posted by Linmic in News, 分享, 推薦, 科技 on March 13th, 2009

不多說，我會買。

palm, palm pre, webOS, wm mobile

No Comments

Convert a MySQL DB from latin1 to UTF8

Posted by Linmic in Linux, MySQL, Python on March 12th, 2009

For work, I have to convert my very old database from latin1 based( with big5 in it ) to UTF8.

My Enviornment:

OS: Gentoo
Python: Python 2.4.3
MySQL: MySQL 5.0.70-log Gentoo Linux mysql-5.0.70-r1
Old encoding: latin1(big5)
Try to convert to: UTF8

And here’s my solution, and memo.
Assume your private parameters as following:

Your old db name: your_old_db
Your new db name: your_new_db
Your mysql account: your_db_acc
Your mysql server’s ip or dn: your_db_host

# dump out a sql through latin1 charset

mysqldump -u wwwuser -p–default-character-set=latin1 your_old_db > output.sql
# — fix origin output.sql’s big5 problem here ( do some regex replacement, it depends ) —
# convert the "real storage encoding" from "big5" to utf8, latin1 is just a tag note in db

piconv -f big5 -t utf8 output.sql > utf8.sql
# replace all charset and collate in sql file, and delete the line which include "SET NAMES latin1"

# for matching, the longer the better ex: match from "type=Mxxx….", you could do this from the beginning of each single line

sed -e ‘s/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/g’ -e ‘s/CHARSET=gbk/CHARSET=utf8/g’ -e ‘s/ collate gbk_bin//g’ -e ‘s/ COLLATE=gbk_bin//g’ -e ‘/SET NAMES latin1/d’ utf8.sql > utf8_after_sed.sql
# echo SET NAMES utf8 to a new file named tmp.sql

echo "SET NAMES utf8;" > tmp.sql
# merge the two files

cat utf8_after_sed.sql >> tmp.sql
# rename the file to utf_final.sql, just a clarify

mv tmp.sql utf8_final.sql
# import to a new unicode based db, we’re done here

mysql -h your_db_host -u your_db_acc -p –default_character_set utf8 your_new_db < utf8_ultimate.sql