Relative Content

Tag Archive for sqlstringascii

Is there an alternative to looking at each character (luckily only 44 or less) to see if the character is outside of the ASCII range 32-126?

Using SQL, I pull a 100 char string from a table and save it to a text file. The bank instead reads this line as having 102 characters and rejects the file for having lines too long. I know that the character in issue is in the ASCII Special Character set and seems to take up 3 spaces when read by a system using the standard ASCII character set of values below 127. Any tips, tricks or solutions you have used?