SQL – Search for special characters
Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to NAV \ Business Central.
These characters (even if accepted) could then give problems to searches, XML exports, blocking the sending of documents.
How to find them quickly?
It is possible to execute an SQL query that checks all the ASCII…
Continue Reading rs’s Article on their blog
SQL – Search for special characters
Sometimes it may happen that by importing data from external sources (even with Web Services), some special characters are written and then uploaded to NAV Business Central. These characters (even if accepted) could then give problems to searches, XML exports, blocking the sending of documents. How to find them quickly?
Blog Syndicated with rs’s Permission
More About This Author
Array
- Business Central11 April 2024MB-820 Beta – Microsoft Dynamics 365 Business Central Developer
- Business Central5 April 2024Business Central 24 Wave1 – Copilot Chat & Analyze List
- Business Central22 March 2024SQL Server: how-to check info about Indexes, Locks & Deadlocks
- Business Central22 March 2024Business Central 2024 release wave1 Launch Event – April 4-10