Flickr mySQL DBA Blog

By Harry Fuecks | August 29, 2006 | PHP

Quick note – Dathan Pattishall, one of Flickr’s db / software engineers has been dropping notes on his new blog mySQL DBA – some fascinating insight and technical tips.

Related to recent UTF-8 discussions…

Rebuilding 4.0 data into 4.1 data
What does mySQL 4.1 do with utf8 and collation
Calculating utf8 sizes for varchars
MySQL 4.1 and insert or Load data warnings
Note about utf8_bin
Quick php script to figure out bad utf8 characters. (Blogger.com really needs to sort out syntax formatting and highlighting!)

Will update the wiki in due course.

Written By:

Harry Fuecks

Harry has been working in corporate IT since 1994, with everything from start-ups to Fortune 100 companies. Outside of office hours he runs phpPatterns: a site dedicated to software design with PHP that aims to raise standards of PHP development. He also maintains Dynamically Typed: SitePoint's PHP blog.

{ 3 comments }

Quaint April 17, 2007 at 11:46 pm: I can now officialy state that dp.SyntaxHighlighter doesn’t work on blogger..
The problem is that blogger posts ALL of your posts (even if you didn’t use the WYSIWYG editor) in a single line.. You code will thus also appear as a single line (syntax highlighter expects Newlines).. It’s just rubbish! From Blogger, that is!
HarryF August 30, 2006 at 4:31 am: If I remember correctly from the test account I created on Blogger.com, aren’t people able to modify certain sections of the template, and even part of the head tag?
OK – have never used blogger so me being grump I guess. Then again perhaps they need to work out some smart defaults here – Dathan certainly knows enough about HTML to cope but is probably time / interest.
malikyte August 29, 2006 at 11:25 pm: (Blogger.com really needs to sort out syntax formatting and highlighting!)
If I remember correctly from the test account I created on Blogger.com, aren’t people able to modify certain sections of the template, and even part of the head tag? If so, a user could easily add the same formatting script that is used right here on Sitepoint, could they not? I think it’s dp.SyntaxHighlighter.
We can’t expect service providers to do everything, can we?! :)