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.