Re: [PHP] Detecting \u0000 in a string...
Casey wrote: On Mon, Mar 17, 2008 at 3:56 AM, Mikey [EMAIL PROTECTED] wrote: Hi! I was wondering if anyone here had experienced a simliar problem to mine. I am updating an Oracle XMLType column with XML built using DOM that is populated with values from an Excel spreadsheet saved out as a CSV. My problem is that for certain (apparently) random rows the xml updated will fail with the error: Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00217: invalid character 0 (\u) Error at line 1 ORA-06512: at SYS.XMLTYPE, line 5 ORA-06512: at line 1 in /path/ob/fu/scated/archive.inc on line 1374 I have googled around and a Java fix for the problem seemed to revolve around a null char being left on the end of the XML string, so I tried stripping the last char from the string but this did not help. I then used an ordUTF8 function I found in the manual notes to see if I could find the null in the string - again, no luck. So my question is whether or not anyone here has a reliable way of detcting and removing \u chars from strings? regards, Mikey -- How about: $str = str_replace(\0, '', $str); -Casey You would think wouldn't you? I even tried asc(0) to no avail. Well, my problem for now has gone away as an ammended version of the spreadsheet did not have these errors, but a weird one, without a doubt! Mikey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Detecting \u0000 in a string...
Hi! I was wondering if anyone here had experienced a simliar problem to mine. I am updating an Oracle XMLType column with XML built using DOM that is populated with values from an Excel spreadsheet saved out as a CSV. My problem is that for certain (apparently) random rows the xml updated will fail with the error: Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00217: invalid character 0 (\u) Error at line 1 ORA-06512: at SYS.XMLTYPE, line 5 ORA-06512: at line 1 in /path/ob/fu/scated/archive.inc on line 1374 I have googled around and a Java fix for the problem seemed to revolve around a null char being left on the end of the XML string, so I tried stripping the last char from the string but this did not help. I then used an ordUTF8 function I found in the manual notes to see if I could find the null in the string - again, no luck. So my question is whether or not anyone here has a reliable way of detcting and removing \u chars from strings? regards, Mikey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Detecting \u0000 in a string...
On Mon, Mar 17, 2008 at 3:56 AM, Mikey [EMAIL PROTECTED] wrote: Hi! I was wondering if anyone here had experienced a simliar problem to mine. I am updating an Oracle XMLType column with XML built using DOM that is populated with values from an Excel spreadsheet saved out as a CSV. My problem is that for certain (apparently) random rows the xml updated will fail with the error: Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00217: invalid character 0 (\u) Error at line 1 ORA-06512: at SYS.XMLTYPE, line 5 ORA-06512: at line 1 in /path/ob/fu/scated/archive.inc on line 1374 I have googled around and a Java fix for the problem seemed to revolve around a null char being left on the end of the XML string, so I tried stripping the last char from the string but this did not help. I then used an ordUTF8 function I found in the manual notes to see if I could find the null in the string - again, no luck. So my question is whether or not anyone here has a reliable way of detcting and removing \u chars from strings? regards, Mikey -- How about: $str = str_replace(\0, '', $str); -Casey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php