Troubleshooting: Export Data error – ‘ ’, hexadecimal value 0x02, is an invalid character: Difference between revisions
Troubleshooting: Export Data error – ‘ ’, hexadecimal value 0x02, is an invalid character (view source)
Revision as of 06:38, 2 March 2023
, 1 year agono edit summary
(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:
Debtor: select * from debtor for xml raw<br/>
Stock: select * from itemuom for xml raw<br/>
Stock UOM: select * from item for xml raw<br/>
| |||
