codepage and UTF-8 on one page

Marianne · #1 (**permalink**) June 18th, 2009, 06:08 AM

Hi guys,
I'm Marianne, been programming in classic ASP for a year now and today, after googling for hours I'm getting a little desperate...

So, we have a SQL database. Some fields are in codepage and some in UTF-8.
I put

Code:

Response.ContentType = "text/html"  
    Response.AddHeader "Content-Type", "text/html;charset=UTF-8"  
    Response.CodePage = 65001   
    Response.CharSet = "UTF-8"

at the top and

Code:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

further down in my <head>
I convert the CP strings to UTF8 using

Code:

Dim TextCodePageIndex : TextCodePageIndex = 1253    '(this could be another value)
set objConvert = server.createobject("C2U2C.clsConvert")
 sWelcome = objConvert.CP2UTF8(TextCodePageIndex, sWelcome)

I get the one text I get directly in UTF-8 showing up properly, but the other texts are all messed up and look nothing like greek.
Then when I comment out the

Code:

Response.AddHeader "Content-Type", "text/html;charset=UTF-8"  
Response.CodePage = 65001

at the top and

Code:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

further down in my <head>, everything looks perfect except for the one string that was UTF-8 already.
Converting that bit of text doesn't do the trick either.
I can't convert it back to codepage first because this is data entered by users so I don't know what codepage to convert it to.
Any ideas?

Old Pedant · #2 (**permalink**) June 18th, 2009, 04:14 PM

I dunno if it works with data from SQL Server, but you *could* try this:

Code:

Session.CodePage = 1253 ' or whatever
someVariable = RS("someFieldInCP1253")
Session.CodePage = 65001
anotherVariable = RS("someFieldInUnicode")
...

Used to work, 10 years ago, with MySQL database (and Access, I think...before Access went all Unicode). The recordset holds (held?) the data in raw database form and the assignment to the variable used the appropriate MBCS conversion, if needed.

A stab in the dark, and ancient technique. Good luck.

Marianne · #3 (**permalink**) June 19th, 2009, 06:52 AM

Thanks Old Pendant, I will give it a go next time me and CodePage will cross paths

Need to download code?

Navigation