#latin1

I encountered some interesting issues when pulling out CSV from my MySQL databases. The core issue was the csv generated was not seemingly compatible with the various spreadsheet readers in Windows. After having a closer look at the file, it turns out to be an encoding issue clearly. As the database was Latin1 encoded, the carriage return was handled as r [shows up as ^M on VI] in some text blobs. That basically resulted in an additional carriage return in the reader and it would break the csv. Here was the way I solved this issue. perl -pie 's/r//g' *.csv This will basically remove all the r  and thus ensure that your reader is able to accept and read the file. You should be able to see the difference when you export the file into the reader.

I encountered some interesting issues when pulling out CSV from my MySQL databases. The core issue was the csv generated was not seemingly compatible with the various spreadsheet readers in Windows. After having a closer look at the file, it turns out to be an encoding issue clearly. As the database was Latin1 encoded, the carriage return was handled as r [shows up as ^M on VI] in some text blobs. That basically resulted in an additional carriage return in the reader and it would break the csv. Here was the way I solved this issue. perl -pie 's/r//g' *.csv This will basically remove all the r  and thus ensure that your reader is able to accept and read the file. You should be able to see the difference when you export the file into the reader.

#Parcial #Latin1 🎉 #exonerado 😃😄😁😋 #Ojoconlasmayúsculasen elmediodeunaoración #lol😸🙆 (presso CeRP del Este)

Ja és a sync alerter is, mennyen a sunyiba

— Mike Perham (@mperham) February 22, 2012

In this article I'll fill you in on exactly what every working programmer should know. All that stuff about "plain text = ascii = characters are 8 bits" is not only wrong, it's hopelessly wrong, and if you're still programming that way, you're not much better than a medical doctor who doesn't believe in germs.

In this study piece I'll be covering both the underlying concepts as well as providing a quick reference for the most commonly used standards.