[WebDNA] Re: Character conversion on storage to database

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108114
interpreted = N
texte = --0015175d03a0ee322004b6bcb9e4 Content-Type: text/plain; charset=UTF-8 Hi all, In case this is useful to anyone else, I have figured out the following conversions: Linefeed / carriage return - %0D%0A is stored as %0B Non-breaking space - %C2%0A is stored as %0A Horizontal tab - %09 is stored as %1D so I'm using the following table to strip these characters out before an append (where the submitted field contains HTML): [table name=stripChars&fields=from,to] %0D %0A %C2 %A0 %09 [/table] There is a tab obviously at the end of each line above. - Tom --0015175d03a0ee322004b6bcb9e4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

In case this is useful to anyone else, I have fi= gured out the following conversions:

Linefeed / carriage return - %0D%0A is stored as %0B
Non-bre= aking space - %C2%0A is stored as %0A
Horizontal tab - %09 is sto= red as %1D

so I'm using the follo= wing table to strip these characters out before an append (where the submit= ted field contains HTML):

[table name=3DstripChars&fields=3Dfrom,to]
%0D
%0A
%C2
%A0
%09
[/table]

There is a tab obvious= ly at the end of each line above.

- Tom


--0015175d03a0ee322004b6bcb9e4-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] Character conversion on storage to database (Tom Duke 2012)
--0015175d03a0ee322004b6bcb9e4 Content-Type: text/plain; charset=UTF-8 Hi all, In case this is useful to anyone else, I have figured out the following conversions: Linefeed / carriage return - %0D%0A is stored as %0B Non-breaking space - %C2%0A is stored as %0A Horizontal tab - %09 is stored as %1D so I'm using the following table to strip these characters out before an append (where the submitted field contains HTML): [table name=stripChars&fields=from,to] %0D %0A %C2 %A0 %09 [/table] There is a tab obviously at the end of each line above. - Tom --0015175d03a0ee322004b6bcb9e4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi all,

In case this is useful to anyone else, I have fi= gured out the following conversions:

Linefeed / carriage return - %0D%0A is stored as %0B
Non-bre= aking space - %C2%0A is stored as %0A
Horizontal tab - %09 is sto= red as %1D

so I'm using the follo= wing table to strip these characters out before an append (where the submit= ted field contains HTML):

[table name=3DstripChars&fields=3Dfrom,to]
%0D
%0A
%C2
%A0
%09
[/table]

There is a tab obvious= ly at the end of each line above.

- Tom


--0015175d03a0ee322004b6bcb9e4-- 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:

shortening the cart (1998) Custom WebCat Prefs ... (1997) WebCatalog can't find database (1997) emailer w/F2 (1997) Use of & in text areas.... (1998) Multiple prices (1997) emailer (1997) Claris HomePage messes up the code (1997) encrypt/decrypt password with authenticate (2002) Bug in 4.5 - Needs to be fixed ASAP. (2002) forming a SKU (1999) Authenticate Checker - different versions ?? (1998) Fw: Linux w/ apache (2000) PCSDecrypt bugs still unfixed ... (2000) Storing Data (2002) shownext (1997) [WebDNA] Emailer breaking format (2015) WebCatalog can't find database (1997) Keyword search (2004) Emailer port change (1997)