Custom Discovery Roof Rack
August, 2012 - Sierra Backpacking
July 22nd, 2012 - Hiking in Santa Barbara
July 15th, 2012 - Valley of Fire
May 5th, 2012 - Afton Canyon
April 28th, 2012 - Devils Playground
Convict Creek Trail
January 2012 - Mustangs
January 3rd, 2012 - Heart Lake
August 7th, 2011 - Kelso Dunes
August 5th, 2011 - Lundy Canyon Hike
August 2011, Mammoth Archery
Birds in the garden
June 4th, 2011 - San Gorgonio
May 29th, 2011 - Sequoia National Forest
April 23rd, 2011 - Living Desert
April 2nd, 2011 - Death Valley
March 8th, 2011 - Mountain Palm Springs
February 13th, 2011 - Iron Smelt
November 13th, 2010 - Mojave
October, 2010 - Mammoth
September, 2010 - Mammoth
September, 2010 - Duck Lake Trail Backpacking
Iron bloom forging
August 28th, 2010 - Mt. San Jacinto
OSM Import: US Designated Wilderness
July 25th, 2010 - Mojave Mustangs
July 17th, 2010 - Mojave Exploration
Bloomery furnace iron smelting
Open Street Map: Mojave Project
June 13th, 2010 - Mojave
June 6th, 2010 - El Cajon Trails
Wolf Mountain Sanctuary
March 28th, 2010 - Salton Sea
March 21st, 2010 - South Main Divide
March 13th, 2010 - Anza Borrego Wildflowers
March 7th, 2010 - CSULB Japanese Garden
February 2010 - Mammoth
Dakota and Asha Celebrate Christmas, 2009
November 21st, 2009 - Mojave Road
November 14th, 2009 - Anza Borrego
Exploring The East Mojave: The Afton Canyon Area
Broken flex plate
Remote Image Serving
Astro/night photography in Inyo National Forest
Wild Mustang Sightings
September 26th, 2009 - Night Photography In Frazier Park
August 15th, 2009 - Catalina dive trip
January 24th, 2009 - Mojave Exploration
July 2008 Mammoth Vacation
President Barack Obama!
April 12th, 2008 - Wildflowers and Landmarks
My Grandfather's Alfa Romeo Spider
March 8th, 2008 - Carrizo Plain
Bridge To Nowhere
October 20th, 2007 - Big Bear Camping
October 22nd, 2007 - Fire
Scottish Highlands, Aug 7th, 2006
Scottish Highlands, Aug 6th, 2006
August 5th, 2007 - Duck Lake Trail
May 26th, 2007 - Kelso Dunes
Culloden Battlefield, Aug 5th, 2006
May 20th, 2006 - Irwindale Renaissance Faire
Edinburgh, Aug 4th, 2006
The Clifs of Moher, Aug 3rd, 2006
The Burren, Aug 2nd, 2006
Bunratty Castle, Aug 1st, 2006
May 5th, 2007 - Mojave
Truck Audio/Data Network
2007 - Master Bath Remodel
The Ring of Kerry, Jul 31st, 2006
Victory in 2006!
Blarney and Killarney, Jul 30th, 2006
Dublin and Cork, Jul 29th, 2006
Dublin, Jul 27th & 28th, 2006
What Can I Do?
April 30th, 2006 - Anza Borrego
New desktop: Intel 805 D
Jan 7th and 14th, 2006 - Hiking
Whiting Ranch Hiking
Digital Photography with Linux
September 5th, 2005 - Living Desert
August 19th, 2005 - Mammoth
Hiking and Photography
July 30th, 2005 - Tucker Wildlife Sanctuary
Death, Fright and Photography
May 14th, 2005 - Red Rock
April 2nd, 2005 - Death Valley
Count Every Vote Act of 2005
Linear Logic ScanGuage
November 6, 2004 - Mojave
Super Tuesday, 2004
Canon A80 Camera
Jul 25, 2004 - Death Valley
May 4th, 2004
Landscaping - My Front Slope
Stump Pullin' Yeeee Haw!
Feb 22nd, 2004
Feb 16th, 2004
PostgreSQL Logfile Analysis
Mountains? Desert? Jan 30th, 2004
Jan 28th, 2004
Ceiling Cargo Basket
Front Bumper Version 2
Land Rover Valve Jobs
The Matrix: Revolutions
Greg Davis CDL Linkage
Mom's Turkey Gravy
Julian Pie Company
The KB1DIG 2-meter Halo Antenna
Gardening is hard!
Aug 13th, 2003
SQL and Perl
Jul 9th, 2003
Jun 17th, 2003
Some People's Comments
Dakota is a silly dog
The Matrix: Reloaded
Chris' Stage Bottle Harness
April 23rd, 2003
DVD Burning Under Linux
My Satellite Phone
My Near-Death Experience
Laser Cannon Revival
Front Bumper, Version 2
KPC 3 Plus and HTX-252
Moving, moving moving...
New new house
In Truck Dr. Pepper
My Favorite Toilet
Late Thoughts: Dr. Pepper Cooler
265/75-R16 Tires on a DII
George W. Bush
Horses Sep 14 2002
Sawdust Bellydancing 2002
August 17th Yukon Dives
My Custom Front Bumper
Bracketless, Renamable Links
Jul 28 2002 Day Trip
Jedi Group, my T1 and money
A Bumperless Discovery!
My Custom Rear Bumper
Vanessa's 24th Birthday
Jun 30th Dive to Long Beach Canyon
PHP/PostgreSQL String Quoting
Tonsillectomy, Uvulaectomy and Turbinite Reduction
240 Watt CO2 Laser Cannon
The Tulsa Rib Company
The quality of hard disks these days
Email notification of articles
Email notification of comments
erikburrows.com source code
Renisance Faire Jun 9, 2002
Computers hate me, and it is mutual.
Star Wars Sucks!
Horses, Jun 1, 2002
Land Rover Mileage
Insomnia, Robin goes evil.
100 Watt Diode Laser Test Firing 1
2001: A Space Odyssey
TDI Deco Class
Horses, Apr 30, 2002
My Truck Batteries
The Zope Bible
100 Watt Diode Laser
The New www.erikburrows.com
Hunter the Kitty
Matts Desert Pics
|PHP/PostgreSQL String Quoting -   2002/07/01||Viewed 557 times this month, last update: 2004/03/14|
|Is borked! Ugh... To mad to talk about it.|
You'd be supprized how hard it is to get a word like "You'd" into a database.
Ok, now, after like three hours of work, breaking lots of stuff, decreasing security, and breaking jon's site too, I can finally have single quotes in node titles. Sooo worth it. NOT!
Ok, it's not quite as borked as I thought it was. It turns out PHP has this thing called 'magic quoting', which quotes a single-quote character as backslash-quote. Postgres doesn't like this, since it wants to have single quotes as two single quotes, not an escaped quote. Yikes! Notice above I was asking where all the damn backslashes were comming from. Sheesh.
So, turning off magic quoting, and doing my own damn quoting fixes the problem. Happy erik.
Erik (2002-07-01): It\'s been a crappy day.
Erik (2002-07-01): No, I wouldn\'t be supprized, Erik.
Erik (2002-07-01): Can someone tell me where these damned backslashes are commin\' from?
Erik (2002-07-01): I'm too tired for this. Quick fix.
Erik (2002-07-01): It's ok Erik, take break. Eat some ice cream. Decompress a little... Hey, that reminds me... I should write about my last dive with Chris Bell!
Matt Bell (2002-07-01): Look out, Erik is starting to talk to himself in his own comments... Must be time for more caffeine.
Erik (2002-07-02): I'm happy for you erik.
Steve Kehlet (2002-09-25): I've run into the same problem but with oracle, in which case it's worse, because you don't want mysql escaping quotes with backslashes, since you want to do a double quote ('') instead. Here's my php.ini:
; Magic quotes for incoming GET/POST/Cookie data.
magic_quotes_gpc = Off
; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
magic_quotes_runtime = Off
; Use Sybase-style magic quotes (escape ' with '' instead of ').
magic_quotes_sybase = Off
Erik (2002-09-25): Yeah, I found that Magic Quoting stuff. For PostgreSQL, I turn those off, and pass strings through pg_escape_string(), which is new to PHP 4.