UPDATE: We're opening it up to a greater audience. So even if you're not tech/web related, feel free to come along anyway. Yesterday whilst I was in the office (also known as The Vortex), I was reading my Twitter stream — as I so often do — and I came across this tweet from @bostinbloke .
It's not often I have to worry too much about the minutia of database administration... well, I try not to. But this question on StackOverflow got me intrigued, so I put on my trilby. labratmatt was having a bit of a problem with inserting data into a MySQL table with field defined as DECIMAL(3,2). Can you guess what his problem was? That's right.... 9.99! How did you guess? This has got to be one of the most popular MySQL-related Google searches. The initial problem is easy to solve... correct the presumptuous field definition. However, the underlying problem is really why his data was being truncated, even inserted incorrectly. You may notice the same if you run MySQL (v5.0+) from a default setup on other field types: VARCHAR for example, where you set a maximum field length. When you INSERT data that is too long it simply gets truncated. Not hugely worrying you may think, especially in development and testing phases. True. But this wasn't enough for me, so I went on a ...
Hey folks! Nice to have you visit. I've moved just a short distance. Please join me to keep up with my latest antics! I'm going to keep this site up for posterity though :) In our office, we have a small custom, headless 32-bit PC running Ubuntu Server 8.10 (Intrepid Ibex). It's ideally suited as our testing platform web server, file server, SVN server... well you get the picture. I've been trying to set up a VPN through a Linksys-Cisco router we purchased (WRVS4400N), but have hit one snag after another (thanks to Cisco's non-support of anything other than Windows). Then it hit me: use Dropbox! A few free Dropbox accounts is all we will need for now between us and it creates instant versioning and backups of all of our critical files - something we weren't doing properly up until now - plus allowing us to interact with the file system locally rather than over the network. A super idea! Problem 1: Dropbox is not officially supported for command-line-only...
Comments