PHP 4.0 Bug #6610: HTMLSpecialChars parse error

From: gberenfield@berenfield.com Operating system: Redhat Linux 6.2 PHP version: 4.0.2 PHP Bug Type: *XML functions Bug description: HTMLSpecialChars parse error I've verified the following problem (at least it was for me!) in 4.0.2 with HTMLSpecialChars(): If parsing a string that contains a single-quote character (the ' character), it now translates it to &#039; which broke a few pages I wrote using ODBCSocketServer. e.g. $sql3="select imitmidx_sql.item_no from imitmidx_sql where (imitmidx_sql.mat_cost_type='DRM') and (imitmidx_sql.item_no>='".$specno."') and (imitmidx_sql.item_no<'".$ends."')"; echo (HTMLSpecialChars($sql3)."\n<P>"); This spits out: select imitmidx_sql.item_no from imitmidx_sql where (imitmidx_sql.mat_cost_type=&#039;DRM&#039;) and (imitmidx_sql.item_no&gt;=&#039;&#039;) and (imitmidx_sql.item_no&lt;&#039;&#039;) <P> To the web browser (raw HTML format). Again, this may not be a bug and is actually a fix of the HTMLSpecialChars function but it's breaking SQL calls via ODBCSocketServer 0.92. -Greg