Convert UTF-8 String Classic ASP to SQL Database

by

Paul’s answer isn’t wrong but it is not the only part to consider:

You will need to go through each of these steps to make sure that you are getting consistent results;

IMPORTANT: These steps have to be performed on each and every page in your web application or you will have problems (emphasized by Paul’s comment).

  1. Each page needs to be saved using UTF-8 encoding double check this as some IDEs will default to Windows-1252 (also often misnamed as “ANSI”).

  2. Each page will need the following line added as the very first line in the page, to make this easier I put this along with some other values in an include file so I can include them in each page as I go.

    Include File – page_encoding.asp
    <%@Language="VBScript" CodePage = 65001 %>
<% 
  Response.CharSet = "UTF-8"
  Response.CodePage = 65001
%>

    Usage in the top of an ASP page (prefer to put in a config folder at the root of the web)

    <!-- #include virtual="/config/page_encoding.asp" -->

    Response.Charset = "UTF-8" is the equivalent of setting the ;charset in the HTTP content-type header.
    Response.CodePage = 65001 tell’s ASP to process all dynamic strings as UTF-8.

  3. Include files in the page will also have to be saved using UTF-8 encoding (double check these also).

Follow these steps and your page will work, your problem at the moment is some pages are being interpreted as Windows-1252 while others are being treated as UTF-8 and you’re ending up with a mis-match in encoding.

More Related Contents:

  1. How do I see what character set a MySQL database / table / column is?
  2. Using Stored Procedure in Classical ASP .. execute and get results
  3. How to use ASP variables in SQL statement
  4. PostgreSQL: encoding problems on Windows when using psql command line utility
  5. Convert text value in SQL Server from UTF8 to ISO 8859-1
  6. SQL insert into database with apostrophe
  7. How to make a parametrized SQL Query on Classic ASP?
  8. operation not allowed when the object is closed when running more advanced query
  9. Error trying to call stored procedure with prepared statement
  10. MySQL: Get character-set of database or table or column?
  11. I dont know sql syntax for my table [closed]
  12. Making a dynamic pivot table but without using the fiddle
  13. Get top 1 row of each group
  14. Entity Attribute Value Database vs. strict Relational Model Ecommerce
  15. PostgreSQL GROUP BY different from MySQL?
  16. How can I import a JSON file into PostgreSQL?
  17. Add Foreign Key relationship between two Databases
  18. Escaping ampersand character in SQL string
  19. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  20. SQL Case Expression Syntax?
  21. Difference between Top and Limit Keyword in SQL
  22. Query comparing dates in SQL
  23. Mysql: how to select groups having certain values?
  24. Return setof record (virtual table) from function
  25. OVER clause in Oracle
  26. PARTITION BY with and without KEEP in Oracle
  27. sqlite equivalent of row_number() over ( partition by …?
  28. Stored procedure that exports data into csv files only exports to one file
  29. Primary key/foreign Key naming convention [closed]
  30. Exporting a CLOB to a text file using Oracle SQL Developer

Leave a Comment