I am having the most frustrating problem. Each day I receive an export from our mainframe which contains data about courses for our course catalog. The data in the mainframe contains quotation marks. The CSV file that is pushed over contains quotation marks. The data after it is imported into the table, contains â€œ.
HOW THE DATA APPEARS IN THE TABLE:
Advanced literature seminars that focus on a period or topic in British literature. Recent topics have included â€œNon-Shakespearean Early Modern British Drama,â€ â€œCrime and Victorian Literature,â€ â€œThe Rise of the English Novelâ€
HOW THE DATA APPEARS IN THE CSV FILE:
Advanced literature seminars that focus on a period or topic in British literature. Recent topics have included "Non-Shakespearean Early Modern British Drama," "Crime and Victorian Literature," "The Rise of the English Novel".
I have been researching this and other articles say maybe the table encoding is wrong. I tracked down the encoding on the table, which is SQL_Latin1_General_CP1_CI_
AS and the articles suggest it should be UTF-8. Any idea how to change this? I found a lot about how to change it in mySQL, but not SQL Server.
Also, can I just change it at the table level or does it have to be applied to the entire database? I'd rather not break other things that seem to be working at the moment.