[wp-trac] [WordPress Trac] #4647: Text in database is inconsistently entity-encoded

[WordPress Trac]

#4647: Text in database is inconsistently entity-encoded
------------------------+---------------------------------------------------
 Reporter:  redsweater  |       Owner:  anonymous
     Type:  defect      |      Status:  new      
 Priority:  normal      |   Milestone:           
Component:  General     |     Version:  2.2.1    
 Severity:  normal      |    Keywords:           
------------------------+---------------------------------------------------
 I've noticed that some text, e.g. the names of categories and the
 post_content, are stored in the database with XML-compatible (I think)
 entity encoding. For instance, the & character is stored in the database
 as "&"

 Other fields, such as the Excerpt and Title for instance, store the same &
 character verbatim in the field as &.

 It seems that for consistency, the text in the database should be of a
 standardized form. I would vote for not storing entity encoding in the
 database, as it seems more of a presentational thing.

 To observe the issue, just write a test post in which the & character for
 instance appears in all possible text fields. Then observe the database
 directly to see what has happened.

 This has particularly vulgar affects on the sanity of the text values
 returned by the XML-RPC interface, which I'll describe in another bug
 report.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4647>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software