SQL – Search for special characters

Posted By Roberto Stefanetti on 27 Sep 2022 in Business Central

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

Roberto Stefanetti

Array

Array

• Business Central2023.03.03Business Central 22 (2023 Wave1) Preview and BC Launch Event
• Business Central2023.02.23Business Central 2023 Wave1, some interesting features
• Business Central2023.01.08ChatGPT di OpenAI test con Microsoft AL Language: creazione di una app per leggere una pagina web e salvare i dati presenti nella pagina in un foglio Excel
• Business Central2022.12.16Business Central from On-Premise to Cloud APIs