codepage and UTF-8 on one page

Marianne · June 18th, 2009, 05:08 AM

Hi guys,
I've got utf-8 data from one table and codepage from another table, and I need to display both on one page.
Any ideas?

Old Pedant · June 18th, 2009, 03: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 · June 19th, 2009, 05:52 AM

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