mysql text字段换行符

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 插入数据时处理换行符
def insert_text(text):
    normalized_text = text.replace('\r\n', '\n').replace('\r', '\n')
    sql = "INSERT INTO your_table (text_column) VALUES (%s)"
    cursor.execute(sql, (normalized_text,))
    db.commit()

# 查询数据时处理换行符
def get_text():
    cursor.execute("SELECT text_column FROM your_table WHERE id = 1")
    result = cursor.fetchone()
    if result:
        text = result[0]
        # 根据目标操作系统转换换行符
        if os.name == 'nt':
            text = text.replace('\n', '\r\n')
        return text

# 示例使用
insert_text("Hello\nWorld\r\nThis is a test.")
print(get_text())

cursor.close()
db.close()