我正在尝试将字符串the United Nations’ Sustainable Development Goals (SDGs)保存到csv中。

如果我使用utf-8作为编码，字符串中的撇号将转换为ASCII字符

import csv
str_ = "the United Nations’ Sustainable Development Goals (SDGs)"

#write to a csv file
with open("output.csv", 'w', newline='', encoding='utf-8') as file:
    csv_writer = csv.writer(file,delimiter=",")
    csv_writer.writerow([str_])

#read from the csv file created above
with open("output.csv",newline='') as file:
    csv_reader = csv.reader(file)

    for row in csv_reader:
        print(row)

结果是['the United Nations’ Sustainable Development Goals (SDGs)']

如果我使用cp 1252作为编码，则字符串中的撇号将被保留，如您在结果中所见

import csv
str_ = "the United Nations’ Sustainable Development Goals (SDGs)"

#write to a csv file
with open("output.csv", 'w', newline='', encoding='cp1252') as file:
    csv_writer = csv.writer(file,delimiter=",")
    csv_writer.writerow([str_])

#read from the csv file created above
with open("output.csv",newline='') as file:
    csv_reader = csv.reader(file)

    for row in csv_reader:
        print(row)

我得到的结果是['the United Nations' Sustainable Development Goals (SDGs)']，这是理想的

如果我想保留特殊字符，我应该使用什么编码？使用utf-8比使用cp 1252有什么好处？

我的用例是将CSV中的行提供给语言模型（GPT），因此我希望文本是“英语”/ Unchanged。
我在Windows 11上使用Python 3.8