Troubleshooting: Export Data error – ‘ ’, hexadecimal value 0x02, is an invalid character: Difference between revisions
Content added Content deleted
(Created page with "'''Question:''' When I try to export all data, it prompted an error “ ‘ ‘. hexadecimal value 0x02, is an invalid character”. Why? '''Version:''' 1.8 / 1.9 / 2.0 File:Hexadecimal1.png <u><b>Possible Reason:</b></u> System detected there are special characters used in the database. <u><b>Solution:</b></u> 1) You need to find out the error comes from which table. Normally, it is from Creditor, Debtor or Stock Item. You may try to <span style='color:red'...") |
No edit summary |
||
Line 19: | Line 19: | ||
Debtor: select * from debtor for xml raw<br/> |
Debtor: select * from debtor for xml raw<br/> |
||
Creditor: select * from creditor for xml raw<br/> |
|||
Stock: select * from itemuom for xml raw<br/> |
Stock: select * from itemuom for xml raw<br/> |
||
Stock UOM: select * from item for xml raw<br/> |
Stock UOM: select * from item for xml raw<br/> |