test #3 using Admin interface; ECODE, CODE, TT, and PRE
Saved using New on Admin bar
On initial edit using the story editor; the only entry here with "nbsp" named character entities was the first one, with ECODE.
Using the ECODE element:
mysql> describe comment_text ;
+---------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| cid | int(10) unsigned | NO | PRI | NULL | |
| comment | mediumtext | NO | | NULL | |
+---------+------------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
Using the CODE element:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using just TT element:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using just PRE element:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using PRE and then TT:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using TT and then PRE:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using the CODE element:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using the CODE and TT elements:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using the CODE and PRE elements:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using the TT and CODE elements:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Using the PRE and CODE elements:
mysql> describe comment_text ;+---------+------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+------------------+------+-----+---------+-------+| cid | int(10) unsigned | NO | PRI | NULL | || comment | mediumtext | NO | | NULL | |+---------+------------------+------+-----+---------+-------+2 rows in set (0.01 sec)
Read more of this story at SoylentNews.