Displaying TIS620 mysql on UTF8 page

Posted on: Thu, 06/02/2011 - 16:48 By: dae

The ghost from the past is my MySQL database encoded in tis620. Worse, the table and the column itself is labelled as iso-8859-1. Of course, if the web page is to be "viewed" as tis620, all I must to is to simply use

SET NAMES tis620;

In my php code. However, this is not the case because the page itself is utf8.

What comes to help me is iconv. In short, this is what I did.


Posted on: Wed, 11/03/2010 - 03:08 By: dae

It's that time of the year again.

Support Wikipedia

This is not a donation. This is... Admiration.

Songs and Memories

Posted on: Mon, 09/06/2010 - 01:08 By: dae

On Sat, I attended TEDxKrungthep, an independent TED event organized by local TED enthusiasts and the final speaker is Bojo, a choir master. He led all audiences to sing Heal the World by Michael Jackson. The strange thing for me is that, years ago, this is one of songs that I had kept cassette (yes, there is a thing called tape cassette at that time) nearby all the time but somehow, I forgot to include it in my iPhone. It simply get lost in time.

Semper Fidelis

Posted on: Thu, 05/20/2010 - 00:35 By: dae

I am not a student of history nor have ever wished to be one. I lack background knowledge so required to judiciously analyze current event. Moreover, I cannot faithfully say that I understand their desire, their hatred nor their anger. You can be assured that you won’t find any attempt in justifying nor rationalizing the course of current event here. I won’t bother condemn nor praise any decision nor anybody.

Diet Diary #53 -- #69

Posted on: Tue, 05/18/2010 - 16:38 By: dae

Last two weeks were very busy one for me. I DID keep track of my weight but couldn't record my eating. Eating time is totally lost. Here is the best that my memory could serve.

1 May 2010, Sat

morning weight: 82.0 kg

completely lost track of meals.

2 May 2010, Sun

morning weight: 82.3 kg

BF: 2 Bananas + water Lunch: ข้าวราดแกง Dinner: นิตยาไก่ย่าง

Bo's father-side grandma passed away today.

3 May 2010, Mon

morning weight: 82.6 kg

Diet Diary #48 -- #52

Posted on: Sat, 05/01/2010 - 13:27 By: dae

26 April 2010, Mon

morning weight: 82.0 kg (ซาลาเปา Spree does not kill me)

09:00 BF: 2 Bananas + water 12:30 Lunch: ข้าว + ปลาทอด 18:15 Dinner: ข้าว + ทอดมัน + กะหล่ำปลีดอง + ไข่ลูกเขย 04:00 go to bed

The last day at IOI camp. All I can remember is that I ate a lot of stack today. Lays, Tarts, Cola, Dim Sum ,etc....

27 April 2010, Tue

morning weight: 82.6 kg (No banana!)

10:00 BF: 2 Bananas + water 12:30 Lunch: ไก่ย่าง + ข้าวเหนียว + ส้มตำ + ลาบ + ต้มแซ่บ 20:15 Dinner: มาม่าผัด + ขนมจีบ + ยำสาหร่าย 04:00 go to bed

Diet Diary #46 , #47

Posted on: Mon, 04/26/2010 - 04:52 By: dae

24 April 2010, Sat

morning weight: 81.8 kg (slightly upward)

10:00 BF: 2 Bananas + water 12:30 Lunch: ก๋วยเตี๋ยวไก่ + ข้าวขาหมู 14:00 Snack: ขนมปัง 16:00 Snack: ซาลาเปา 16:10 Snack: ซาลาเปา 16:20 Snack: ซาลาเปา 18:30 Dinner: Fillet Minion steak + lots of side dishes 19:20 Snack: ซาลาเปา 20:20 Snack: ซาลาเปา 03:00 go to bed

No more salad today, but in the evening we went to Cowboy land, a nearby steak house. For the total of 12 people, we spend around 4,000 baht for dinner. I ate ซาลาเปาใส้หมูแดง all day.

25 April 2010, Sun

Diet Diary #42 -- #45

Posted on: Sat, 04/24/2010 - 00:03 By: dae

20 April 2010, Tue

morning weight: 82.9 kg (Is this possible!!)

08:00 BF: 2 Bananas + water 12:30 Lunch: Tuna Salad (350g) + Tuna spread & Cracker 16:00 Snack: ทาโร่ยักษ์ (another souvenir from Korea) 18:00 Dinner: ข้าวราดแกง 01:30 go to bed

Surprised!!! My weight drop 1 kg in a day! Either my scale is broken or Morning Banana is working as it claims. In the book, it is said that excess weight from short-term eating spree can be siphon quickly. I guess it's the former case, though.

21 April 2010, Wed

morning weight: 82.5 kg (Dwindle)

Subscribe to