Nixser.com

If you have gone through my previous post, you should now have both php and asp.net running on your windows machine, it’s time to go on further. I’m going to setup both MySQL and SQL Server 2000 on this machine.

MySQL
I’ve got a lot of experiences for php and mysql on my Debian box, installation was hassle-free with Debian package manager. Now on windows, let’s see what can it be. First thing first, get your copy of MySQL windows installer at MySQL download page. Choose the Windows Essentials installer package to download. Go with the standard installation, provide a root password for the new MySQL instance.

Introduction
This blog entry is about technical issue regarding data manipulation in mysql, with tool like phpmyadmin. Data stored in Mysql is retrived/input with PHP pages. If you can’t understand the topic at all, please don’t continue.

Problem
I’ve been dealing with web projects for years. Mostly with PAM(php + apache + mysql) environment. When it comes to something that requires user’s interactions( comment, forum, etc), I always use UTF-8 as the default charset in web pages. This ensures that different characters(simplified chinese, traditional chinese, japanese etc)can be displayed on same page nicely without users have to change the character encoding in the browser.

mysql, phpmyadmin, www