Chances are, you will
run into special characters within your data. So if you're working with CSV, what special characters are actually supported?
Technically, all of them!
There are no specified limits of what characters can be used in a CSV file
. What limits you is how your file is encoded.
If you recall from our article on choosing the right encoding
, UTF-8 is the recommended file encoding, due to its vast support of just about any character possible. If you don't opt for UTF-8, chances are you may run into the dreaded sprinkling of "??????" throughout your file. That's the computer's way of telling you it has no idea what the character you typed is supposed to be!