[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 = --000e0ce0b2b402919c04b6bb3459Content-Type: text/plain; charset=UTF-8Hi all,I am having a problem with odd characters being added to databases causingsquare boxes to display in IE and some other browsers. I think they aredue 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 enteredcharacter. So Chris, can you (or someone else) provide a list of thecharacter conversions that WebDNA does when appending data to a database?The one I know is for a line ending:%0D%0A becomes %0Bbut what original characters cause the following to be appended:%A0%1DThanks- Tom--000e0ce0b2b402919c04b6bb3459Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printableHi 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:
|
- [WebDNA] Character conversion on storage to database (Tom Duke 2012)
|
--000e0ce0b2b402919c04b6bb3459Content-Type: text/plain; charset=UTF-8Hi all,I am having a problem with odd characters being added to databases causingsquare boxes to display in IE and some other browsers. I think they aredue 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 enteredcharacter. So Chris, can you (or someone else) provide a list of thecharacter conversions that WebDNA does when appending data to a database?The one I know is for a line ending:%0D%0A becomes %0Bbut what original characters cause the following to be appended:%A0%1DThanks- Tom--000e0ce0b2b402919c04b6bb3459Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printableHi 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: