<br><br><div><span class="gmail_quote">2007/8/31, Marcel Wiesweg <<a href="mailto:marcel.wiesweg@gmx.de">marcel.wiesweg@gmx.de</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> > > Big question is handling of metadata. I'd like to see whole IPTC Core<br>> > > put into database... For fast querying of those items and making it<br>> > > independent of actual images.
<br>> ><br>> > How many fields does that make?<br>><br>> <a href="http://www.iptc.org/std/Iptc4xmpCore/1.0/specification/Iptc4xmpCore_1.0-spe">http://www.iptc.org/std/Iptc4xmpCore/1.0/specification/Iptc4xmpCore_1.0-spe
</a><br>>c-XMPSchema_8.pdf 33:<br>><br>> IPTC Subject-NewsCodes<br>> IPTC Scene-NewsCodes<br>> Country Code<br>> Creator's Contact Info<br>> Contact Info-City<br>> Contact Info-Country<br>> Contact Info-Address
<br>> Contact Info-Postal Code<br>> Contact Info-State/Province<br>> Contact Info-Email<br>> Contact Info-Phone<br>> Contact Info-Web URL<br>> Intellectual Genre<br>> Location<br>> IPTC Scene<br>> IPTC Subject Code
<br>> Creator<br>> Caption/Description<br>> Copyright Notice<br>> Keywords<br>> Title<br>> City<br>> Country<br>> Creator's Jobtitle<br>> Date Created<br>> Caption/Description writer<br>> Headline
<br>> Instructions<br>> Job Identifier<br>> Provider<br>> Source<br>> Province/State<br>> Rights Usage Terms<br>><br>> Note: several of them are of type - Lang Alt which means there can be<br>> several fields: Copyright Notice, Description, Rights Usage Terms, Title
<br><br>So it is clear that there won't be a table with 33 columns but rather a table<br>with key/value pairs. Like the ImageProperties table that already exists. Or<br>do we need extra language information?</blockquote>
</div><br>What do want to mean by "extra language info" exactly ?<br><br>Gilles<br>