Timeline for How to check for Non-Ascii Characters
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 7, 2021 at 21:02 | comment | added | John | @Fandango68, that's correct. If you highlight all that code in SSMS and hit CTRL-K, CTRL-U it will uncomment all those lines at the same time. CTRL-K, CTRL-C will comment them back. | |
| Dec 6, 2021 at 3:51 | comment | added | Fandango68 | Thanks John. So if I want to id all those special chars, I uncomment all the code? | |
| Dec 5, 2021 at 19:34 | comment | added | John | @fandango68 "it goes the extra step of identifying special characters if you want - uncomment lines 19 - 179 to do so." | |
| Nov 22, 2021 at 3:30 | comment | added | Fandango68 | How does it "work" since you've commented out all the code? | |
| Sep 11, 2021 at 19:06 | comment | added | Ian McGowan | This is brilliant! Probably not as efficient as the accepted answer for finding rows with bad data, but once found this is perfect for analysing what specifically is bad. Thanks so much for sharing. | |
| Dec 13, 2018 at 16:00 | history | answered | John | CC BY-SA 4.0 |