On Mon, 20 Apr 2009 09:14:05 -0700 (PDT), shapper <mdmoura@g...>
wrote:

>Hello,
>
>I creating xml files to hold localized resources such as posts,
>documents, contents, etc.
>
>For example, a post contains the following fields:
>PostID, PostTitle, PostBody, PostCreatedDate, PostUpdatedDate and
>PostIsPublished
>
>Localized Columns:
>PostTitle and PostBody
>
>NO Localized columns:
>PostID, PostCreatedDate, PostUpdatedDate and PostIsPublished
>
>What is the best way to create a XML file structure to hold posts?
>
>I always use SQL databases but in this project I need to use XML files
>that I am not so used to ...


There are many ways but there is at least a standardised way to
reference language in an XML node (tag), using xml:lang

See these pages for a couple of examples of usage and gotchas :
http://www.opentag.com/xmli18nfaq.htm
http://docs.oasis-open.org/dita/v1.1/OS/archspec/xmllang.html
http://www.simonstl.com/xmlprim/xmlupdate/atts.html 

Check the part above on ISO 639 codes for language and locale
specifiers : e.g. en-US vs en-GB and pt-BR vs pt-PT : Portugese
Brazilan vs Portugese Portugal

Be sure that you're dealing with UTF-8 when accepting (web form)
input, DB column processing, and XML output, to avoid any problems
with character sets like ISO-8859-1 (Western European) not defining al
the international characters you need to use in your posts.

HTH
Cheers - Neil
------------------------------------------------
Digital Media MVP : 2004-2009
http://mvp.support.microsoft.com/mvpfaqs