MsAccess/mysql 的编码问题 - 未正确显示重音符号

发布于 2024-11-24 15:55:07 字数 513 浏览 2 评论 0原文

我需要将Access表中的一些数据迁移到mysql。我之前使用过 Mysql 作为后端，MsAccess 作为前端，所以我认为这是理所当然的。在有效的 mysql/Access 组合中，mysql 表采用 latin1_swedish，并且 mysql 和 access 都正确呈现重音标记。

然而，在这个新数据库中，重音符号无法正确显示。我尝试将 mysql 表排序规则从 utf8 更改为 latin1 再更改为 latin1_swedish，但它不起作用。

它的作用是这样的：

Enter ç directly into mysql{
    Mysql displays ç
    Access displays Ã§
}
Enter ç directly into access link table{
    Mysql truncates the accentmark and everything after it.
}

我不知道为什么它在一个中运行良好，而在另一个中却不起作用。有什么建议吗？

原文

I need to migrate some data we have in Access tables to mysql. I have used Mysql as a backend and MsAccess as a frontend before so I figured this was a no brainer. In the mysql/Access combo that works the mysql tables are in latin1_swedish and both mysql and access render accent marks properly.

In this new database however the accent marks are not displaying properly. I've tried alternating the mysql table collation from utf8 to latin1 to latin1_swedish but it isn't working.

What it does is this:

Enter ç directly into mysql{
    Mysql displays ç
    Access displays Ã§
}
Enter ç directly into access link table{
    Mysql truncates the accentmark and everything after it.
}

I don't know why it works fine in one, and not in another. Any suggestions?

分享到QQ

分享到微博