Tom's Web Hosting

If you have been using tags for your weblog entries you can now access those tagged entries from the Tags webpages of your website.

The Tags webpage is a tag cloud of the tags for your weblog entries. The tags can be sorted by alpha or frequency. Each tag links to a webpage listing the weblog entries for that tag.

Following are some examples for Tom's Web Hosting.

• the tags webpage (tag cloud)
• weblog entries with dvice tag
• weblog entries with tom's web hosting tag

In addition a Tags link has been added to your menu.

If you have been using tags for your weblog entries you can now access those tagged entries from your latest feed. Following are some examples for Tom's Web Hosting.

• default latest feed
• weblog entries with dvice tag
• weblog entries with tom's web hosting tag

I just filed an assumed business name registration for Oregon and it went smoothly. The website stated that it would take a day to start processing the registration and that I could monitor the progress in a queue they have on my account. No sooner than I had gone to check the queue it had moved from the pending state to the next! Fantastic!

You can now select from the domain names getYourBlogOn.com, theBlogFactor.com, thinkingBeings.com, and of course tomsWebHosting.com when creating a website.

A Macbook Pro laptop case looks like a newspaper and may just may make your Macbook Pro less of a target for thieves. One improvement I can think of... Allow the user to slip a current sheet of newspaper into a sleeve on the outside of the case.

I needed to change the character set for a MySQL database with which I'm working. It was created with latin1 and I needed it to be in utf-8. Here are some relevant links.

• http://codex.wordpress.org/Converting_Database_Character_Sets
• http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/

My need was pretty simple, convert the database without to much concern for the data itself. So my main challenge was how to loop over the tables in my database and alter the tables. I decided to use the mysql command line. Here is what I came up with...

USE databasename;

DELIMITER //

DROP PROCEDURE IF EXISTS test//

CREATE PROCEDURE test()

    BEGIN

      DECLARE done INT DEFAULT 0;
      DECLARE a CHAR(64);
      DECLARE cur1 CURSOR FOR SHOW TABLES;
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

      OPEN cur1;

      LOOP

        FETCH cur1 INTO a;

        IF NOT done THEN

          SET @s = CONCAT('ALTER TABLE ',a,' CONVERT TO CHARACTER SET utf8');

          PREPARE stmt FROM @s;

          EXECUTE stmt;

          DEALLOCATE PREPARE stmt;

        END IF;

      END LOOP;

      CLOSE cur1;

    END//

DELIMITER ;

This is some truly stunning art!