[WebDNA] Character conversion on storage to database

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108115
interpreted = N
texte = --000e0ce0b2b402919c04b6bb3459 Content-Type: text/plain; charset=UTF-8 Hi all, I am having a problem with odd characters being added to databases causing square boxes to display in IE and some other browsers. I think they are due to characters that are added when people cut and paste from word. I want to strip out the characters before they are added to the database, but my problem is that the stored character is different from the entered character. So Chris, can you (or someone else) provide a list of the character conversions that WebDNA does when appending data to a database? The one I know is for a line ending: %0D%0A becomes %0B but what original characters cause the following to be appended: %A0 %1D Thanks - Tom --000e0ce0b2b402919c04b6bb3459 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

I am having a problem with odd characters being = added to databases causing square boxes to display in IE and some other bro= wsers. =C2=A0 I think they are due to characters that are added when people= cut and paste from word.

I want to strip out the characters before they are adde= d to the database, but my problem is that the stored character is different= from the entered character. =C2=A0 =C2=A0So Chris, can you (or someone els= e) provide a list of the character conversions that WebDNA does when append= ing data to a database?

The one I know is for a line ending:

%0D%0A =C2=A0becomes %0B

but what original = characters cause the following to be appended:

%A0=
%1D

Thanks
- Tom
--000e0ce0b2b402919c04b6bb3459-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] Character conversion on storage to database (Tom Duke 2012)
--000e0ce0b2b402919c04b6bb3459 Content-Type: text/plain; charset=UTF-8 Hi all, I am having a problem with odd characters being added to databases causing square boxes to display in IE and some other browsers. I think they are due to characters that are added when people cut and paste from word. I want to strip out the characters before they are added to the database, but my problem is that the stored character is different from the entered character. So Chris, can you (or someone else) provide a list of the character conversions that WebDNA does when appending data to a database? The one I know is for a line ending: %0D%0A becomes %0B but what original characters cause the following to be appended: %A0 %1D Thanks - Tom --000e0ce0b2b402919c04b6bb3459 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

I am having a problem with odd characters being = added to databases causing square boxes to display in IE and some other bro= wsers. =C2=A0 I think they are due to characters that are added when people= cut and paste from word.

I want to strip out the characters before they are adde= d to the database, but my problem is that the stored character is different= from the entered character. =C2=A0 =C2=A0So Chris, can you (or someone els= e) provide a list of the character conversions that WebDNA does when append= ing data to a database?

The one I know is for a line ending:

%0D%0A =C2=A0becomes %0B

but what original = characters cause the following to be appended:

%A0=
%1D

Thanks
- Tom
--000e0ce0b2b402919c04b6bb3459-- Tom Duke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[unitshipcost] values do NOT write to orderfile (1998) taxTotal, grandTotal (1997) color and size options (1997) Here's how to kill a Butler Database. (1997) wierd [cart] action! (1997) hard carriage returns and sendmail (1998) Negative Quantity to Shopping Cart (2005) Redirect (2000) strange problem listfiles and movefile (2000) Variable Prices (1998) Help formatting search results w/ table (1997) Sorting problem (2002) random images (1997) Sum of Quantities (1997) Multiple instances of database (2003) Location of Browser Info.txt file (1997) required fields (1998) ShipCosts database (1997) Help! WebCat2 bug (1997) Pop-up menu (1998)