经典的asp字符编码 [英] classic asp character encoding

问题描述

我在经典的 asp 站点中遇到了西班牙语字符问题.用户可以在 aspx 页面上的表单中提交他们的姓名/地址.然后，aspx 页面将ajax 发布到一个经典的asp 页面，它所做的一切都存储在我们的Sql 2008 DB 中.我可以在数据库中看到字符没有正确存储.例如，名字看起来像 Mª，而它应该是 Mª.

I'm having a problem with Spanish characters in a classic asp site. A user is able to submit their name/address in a form on an aspx page. The aspx page then does an ajax post to a classic asp page which all it does is stored in our Sql 2008 DB. I can see in the database that the character is not stored correctly. For example the first name looks like Mª where it should be Mª.

然后当我读取该数据并将其显示在文本框中时，它仍然显示 Mª.

When I then read that data and display it in a text box it is still displaying Mª.

我尝试过的事情:

• <%@ Language=VBScript 代码页=65001 %><% Response.Charset="UTF-8" %>
• 将文件编码为 UTF-8(使用记事本++)

还有其他想法吗?我需要回到数据库并先修复字符还是可以在我读取字符并显示它们时完成?

any other ideas? Do I need to go back into the database and fix the characters first or can this be done when I read the characters and display them?

推荐答案

您正在查看的是 UTF-8.它可能完全正确，问题在于您用于查找的工具没有正确处理 UTF-8，要么是因为它不能，要么是因为它没有正确配置.

What you are looking at is UTF-8. It's probably exactly as it should be, and the problem is that the tool you use for the looking is not handling the UTF-8 correctly, either because it cannot, or because it is not configured correctly.

这篇关于经典的asp字符编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！