Brian, thanks for the history and background on this.

Like you, I've thus far not used ;;W output electing to embed
all needed HTML in native format (I was creating Web pages
with DataPerfect long before the release of the /W options).

By way of accolades to Lew, I'm now using DataPerfect
as the underlying database engine for over 20 Web sites. 
It works superbly, flawlessly and with very high performance. 
Pretty remarkable for a technology designed years before
the WWW was conceived!  I too have found it superior to
other databases I've tried for generating HTML pages. 

If we could just get past the internal 78 character text field
limit, I could die happy clutching DataPerfect to my breast. 

Pat



At 05:06 PM 9/18/2009, you wrote:
Hi Pat,
 
I would agree, but from the discussions I had with Lew at the time he made these changes, it could not be done due to the memory constraints of DP.
 
There are only the 5 entities that DP converts. It does not try to do the whole gamut, in fact only the criticals ones for XML and XHTML
 
The reason for the two different versions for underlined and italic  is that in  DP Memo fields DP only supports Underline and Bold formatting, but in converting these into HTML a couple of members said that instead of converting it to an Underline it would be better for them to convert it to an Italic, and Lew was again constrained by his own time and the memory constraints of DP, hence the two versions.
 
I never use the formatting in memo fields, but instead prefer to save formatted text as HTML and then I do not use the ;;W output. I only use the ;;W when I am trying to avoid a characters in my date that would render the HTML or XML invalid if it was used.  In simple non validating HTML much of the time you can get away with it, but in XML and XHTML which is far more strict it is important to use the entities. You sometimes even then might get away with a CDATA section, but I have found that DP’s handling of entities very consistent and workable.
 
There was a problem that someone brought up with me about the use of foreign characters, and for the web work I do I have to manipulate the character conversions in my scripts external to DP.
 
If you compare DP to say Access, and SQL Server and most other RDBMS, you have to use add on tools etc to handle entities, as they do not handle the conversion for you.  I think they might have added to those to the more recent releases but in the past you had to code it. So DP is well above this, and since many of the character encoding standard were introduced way after DP had finished its primary development life, I think it is great that it can handle so much of it natively.
 
Bye
Brian
 
 

From: [email protected] [mailto:[email protected]] On Behalf Of Patrick Riley
Sent: Saturday, 19 September 2009 6:05 AM
To: [email protected]
Subject: Re: [Dataperf] ' (apostrophe) interpreted as ' by the /w switch
 
I've long wished for an externally maintained translation
table to handle this allowing user's to add, delete or
modify what's converted.  Tony could then simply remove
the apostrophe conversion. 

My big /W issue is the inability to use both underline
and italics simultaneously.  If I use the underline version
of the DP executable and try to add italics by imbedding
the HTML codes (<i></i>), the greater than, less than
characters get converted to &gt; and &lt;.  Also, if I manual
insert an HTML character string like &#169; or &copy; (for the copyright
symbol), the apostrophes get converted.

A user defined translation table should support more than
single character strings so you could, as an example, convert
... (three periods) into an horizontal ellipsis or <i> into <i> (to
leave unmodified).

The release notes on the /W options state "characters above
128 are converted to the equivalent Latin character set
characters".  I may misunderstand this but an é (acute e)
entered as ALT+130 is not converted to an &eacute; (or
anything). 

As long as I'm wishing, I'd still love to see internal character
string support increase from 78 to at least 255 characters
.

Pat Riley



At 09:21 AM 9/18/2009, you wrote:

Hi Tony,

If you are using HTML bold tags then why would't you want the apostrophes
conforming?

Regards
Brian


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Tony
Sent: Friday, 18 September 2009 8:27 PM
To: [email protected]
Subject: Re: [Dataperf] ' (apostrophe) interpreted as &apos; by the /w
switch

Brian,

Thanks. A bit of a dilemma since by not using ;;w then you lose Dataperfect
bolding conversion.

Tony

-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of Brian Hancock
Sent: Friday, September 18, 2009 7:18 AM
To: [email protected]
Subject: Re: [Dataperf] ' (apostrophe) interpreted as &apos; by the /w
switch


Hi Tony,

That I believe is by design... The /w combined with the ;;w output switch
converts the standard XML  entity characters into their entity value so
& -> &amp;
< -> &lt;
> -> &gt;
' -> &apos;
" -> &quot;
If you do not want this conversion do not use the ;;w output indicator

Regards
Brian


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Tony
Sent: Friday, 18 September 2009 6:05 AM
To: [email protected]
Subject: [Dataperf] ' (apostrophe) interpreted as &apos; by the /w switch


Hi everyone,

Can someone shed some light as to why this is happening and how to get
around it?

Thanks in advance

Ton

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to