Re: Basic Q - archiving master & child db records - Article 182 - go-pugleaf

Article View: borland.public.delphi.xml

Article #182

Back to borland.public.delphi.xml Previous Next

Re: Basic Q - archiving master & child db records

#182

From: Mikael Eriksson
Date: Mon, 09 Jun 2008 07:48

33 lines
1853 bytes

Tom Conlon skrev:
> Hi,
> 
> I'm looking to save master record and mutiple related child records from 
> multiple child tables for archiving purposes to xml.
> 
> Some Q's:
> 1. Would you recommend using attributes for field names or elements? (sorry 
> if this has been answered many times in the past).
> 2. Regarding string/varchar data - does these need to be encoded prior to 
> saving? (ie. every field)
> 3. Regarding text blob data - does these need to be encoded prior to saving?
> or do people use CDATA instead?
> 
> Any other tips/links especially welcome (esp. delphi-specific).
> 
> Thanks,
> Tom 
> 
> 

Hi!

Here is what I would do.

1. Elements
2. No (If the xml is encoded with utf-8 it takes care of any odd 
characters like ���)
3. Base64 encode the blob data

regards

/MIcke

Technical Details

Message-ID: <484ce051$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder2-2.proxad.net!news.osn.de!diablo2.news.osn.de!feeder.ecngs.de!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <484c40c1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f5d9b,5cdf8374573505eb
X-Google-Attributes: gidf5d9b,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII
Date: Mon, 09 Jun 2008 09:48:48 +0200
From: Mikael Eriksson <micke314@gmail.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.delphi.xml
Subject: Re: Basic Q - archiving master & child db records
References: <484c40c1@newsgroups.borland.com>
In-Reply-To: <484c40c1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 213.50.33.2
Message-ID: <484ce051$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1212997713 213.50.33.2 (9 Jun 2008 00:48:33 -0700)
Lines: 33
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder2-2.proxad.net!news.osn.de!diablo2.news.osn.de!feeder.ecngs.de!ecngs!feeder2.ecngs.de!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message