Mark Foster's Blog

Misadventures in Technology

Entries for September, 2010

How to get the contents of an Oracle CLOB data field in PHP

The Oracle “CLOB” (Character Large Object) is a data type used to store up to 4 Gigabytes of text. Retrieving the contents of a CLOB is not as intuitive as you might think. Let’s say you have a CLOB field/column named “mychars” in an Oracle DB table named “mytable” along with some other fields. You [...]

How to reverse the keyhole on a Kwikset Lever so the teeth face up

So let’s say you just purchased a Kwikset entry lever from Lowes. You manage to get it installed and even get the levers in correct orientation. If you are lucky the keyhole will be correctly oriented so you can insert the key with the teeth up. If you are not so lucky, the keyhole will [...]