diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2009-05-05 03:30:49 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2009-05-05 03:30:49 +0000 |
| commit | 13f8a0dd7baf07ebddc72c1764b5ab13f3c9f42c (patch) | |
| tree | b0d5a2f006c1dd9a528c4eb7eca2e428b40566ac /modules/exif/helpers/exif_installer.php | |
| parent | 2434feabeb9244eabe61d906eafce7adb518319e (diff) | |
Detect input encodings from EXIF/IPTC data and convert to utf-8 as
appropriate. This allows us to switch the exif value column back to
varchar and improves the way that we deal with non-utf8 data in our
embedded EXIF/IPTC data.
Diffstat (limited to 'modules/exif/helpers/exif_installer.php')
| -rw-r--r-- | modules/exif/helpers/exif_installer.php | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/modules/exif/helpers/exif_installer.php b/modules/exif/helpers/exif_installer.php index c5c0b027..4cd1a6b2 100644 --- a/modules/exif/helpers/exif_installer.php +++ b/modules/exif/helpers/exif_installer.php @@ -23,14 +23,11 @@ class exif_installer { if ($version == 0) { $db = Database::instance(); - // we use blob as the data type for the value column because occasionally there's binary - // data embedded in the caption field for photos. This preserves the binary data at the - // expense of natural language collation (which we don't use anyway). $db->query("CREATE TABLE IF NOT EXISTS {exif_keys} ( `id` int(9) NOT NULL auto_increment, `item_id` int(9) NOT NULL, `name` varchar(64) NOT NULL, - `value` varbinary(1536) NOT NULL, + `value` varchar(1536) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); $db->query("CREATE TABLE IF NOT EXISTS {exif_records} ( |