From 6b6a6afa90a6be24ae430324ec5ca7fd83f4fe93 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sesse@debian.org>
Date: Mon, 26 Mar 2007 22:33:08 +0200
Subject: [PATCH] Trim the EXIF values; seems like the Pentax K10D sometimes
 adds extra spaces after its model.

---
 perl/Sesse/pr0n/Index.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index 737eba6..5a635d4 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -156,8 +156,8 @@ sub handler {
 		# Find the equipment used
 		my $eq = $dbh->prepare('
 			SELECT 
-				model.value AS model,
-				coalesce(lens_spec.value, lens.value) AS lens,
+				TRIM(model.value) AS model,
+				coalesce(TRIM(lens_spec.value), TRIM(lens.value)) AS lens,
 				COUNT(*) AS num
 			FROM images i
 				LEFT JOIN exif_info model ON i.id=model.image
-- 
2.39.2