• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Encoding in .CSV import
#1
I've had problems with encoding in .CSV files that I resolved by removing the BOM (Byte Order Mark) from the beginning of the file. But now I notice that several characters are not appearing in the song metadata. A frequent example is the en-dash (the technically proper divider, print-wise, between number ranges that my database uses to show the birth-death years of composers and lyricists--vs. the hyphen), which displays in MSP as the diamond with the ? in it.

I haven't made an exhaustive search of what other characters aren't displayed properly (I only care about French, Spanish, Italian, and German diacritics, and I see that at least the French é with accent aigu  is displayed), but is there some general rule of what encoding I must ensure that I'm feeding to MSP in order to have those characters displayed? I'd like to have this nailed before I import thousands of songs. I picked whatever encoding would coax my exporting database NOT to output a BOM, so I could get everything working. But, as I believe Mike has already decided to strip BOMs in future updates, I'd like for that future to know what encoding choice will give me the en dash plus the Euro diacriticals and have them displayed properly in MSP.

Thanks. - Kevin
Reply


Messages In This Thread
Encoding in .CSV import - by KHS - 03-30-2020, 04:47 AM
RE: Encoding in .CSV import - by Zubersoft - 03-30-2020, 07:37 AM
RE: Encoding in .CSV import - by KHS - 03-30-2020, 10:46 AM
RE: Encoding in .CSV import - by Zubersoft - 03-30-2020, 12:43 PM



Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.