Wild Fruit On The Roadside
It was early morning and I was walking from the town into my house, it’s about 30 minutes walking distance. In the middle of the trip and after the sunrise, I saw this fruit on the roadside.
I didn’t know what fruit is that. It looked delicious, remind me of the wild marquisa I found on the riverside some years ago –when I was a child. Before I picked the fruit to try how is the taste, I took some pictures of that fruit.
Later, I peeled that strange fruit carefully and found a disgusting form of the pulp. Without trying its taste, I knew that no way this fruit will be delicious.
But I couldn’t resist to try it, so I licked its black pulp and there’s almost no taste. Just cold and tasteless so I threw it away and continue my walk.
I use Panoramio to publish those images, if you wonder where did I get that fruit, you can click on the image(s) above and there is a map (Google Maps) that show you where the pictures were taken.
Insert French Characters Into MySQL
I was developing a bi-lingual website, so my custom CMS should be able to accept and display both English and non English characters. For English characters, it’s a piece of cake. But for French characters, I have pulling my hair for days to find out what went wrong with my script.
I have set the database to use UTF-8 encoding, but every time I inserted the text it’s messed up. French characters become a horror, unreadable for everyone.
After several days –literally– I have found the solution: I must set the character set into UTF-8 right before I insert the data!
< ?php
mysql_query("SET CHARACTER SET utf8"); //<--the key!
mysql_query("insert into data values ('$french_chars')");
?>
SET CHARACTER SET utf8
will tell MySQL to store the inserted data using UTF-8 encoding. And it works for me.
