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

https://robertostefanettinavblog.com/2022/09/27/sql-search-for-special-characters/

Blog Syndicated with rs’s Permission

Leave a reply

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
February 2025
MTWTFSS
      1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28   
« Jan   Mar »
Follow
Sign In/Sign Up Sidebar Search
Popular Now
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...