ASP page not reading Foreign Char from DB correctly

[vaibhavjain]

Hello Everyone
I read the answer from Anthony jones on one of the related topic, it did not work for my issue
here is the code snipet
....
if not rstSessionID.EO F then
Response.CodePa ge = 65001
Response.CharSe t = "utf-8"
Response.Write( "Vojenská lékaøská akademie J.E.Purkynì Hradec Králové")
Response.Write( "<BR>")
Response.Write( "<OPTION>UNIVER SITÉ DU QUÉBEC À HULL</OPTION>")
Response.Write( "<BR>")
do while not rstSessionID.EO F
Response.Write( "Records:" & rstSessionID(0) .Value)
Response.Write( "<BR>")
Response.Write( rstSessionID("g l_code_tx3").va lue)
rstSessionID.Mo veNext()
loop
....

when i pass Foreign Char string directly i get it displayed correctly but when i am passing as value from DB it is not showing foreign character

Please Advice

thanks
Vaibhav

[jhardman]

compare the binary data - i would guess you may need to store the data as a blob rather than as text.

Jared