I'm having a problem with an application of mine in the inserting of Nordic and
Asian characters. I'm using a flash application that sends data to an ms access
database with an asp insert page and then reads it out via an asp page. The
special characters are all coming out like ?? ?? (? and ?). The problem I have
is I knwo it is an encoding issue but where do I specify it? In my insert.asp
page or in the Flash actionscript or both and what exactly do I put. This is
driving me crazy as this application worked previously just fine. I'm
enclosing my code to see if someone has an idea of what I should add and where.

Thanks in advance for the help!

David

Here is the actionscript I am using:
------------
var first_name, last_name, company, evaluators_role, years_known, stmt1,
stmt2, stmt3, stmt4, stmt5, stmt6, stmt7, stmt8, stmt9, stmt10, stmt11, stmt12,
stmt13, stmt14, stmt15, stmt16, stmt17, stmt18, stmt19, stmt20, comments1
submit.onPress = function(){
if(first_name.text!="" && last_name.text!="" && company.text!="" &&
evluators_role.value!="" && years_known.text!="" && stmt1.component!="" &&
stmt2.component!="" && stmt3.component!="" && stmt4.component!="" &&
stmt5.component!="" && stmt6.component!="" && stmt7.component!="" &&
stmt8.component!="" && stmt9.component!="" && stmt10.component!="" &&
stmt11.component!="" && stmt12.component!="" && stmt13.component!="" &&
stmt14.component!="" && stmt15.component!="" && stmt16.component!="" &&
stmt17.component!="" && stmt18.component!="" && stmt19.component!="" &&
stmt20.component!="" && comments1.text!=""){
myData.first_name = first_name.text
myData.last_name = last_name.text
myData.company = company.text
myData.evaluators_role = evaluators_role.value
myData.years_known = years_known.text
myData.stmt1 = stmt1.stmt1
myData.stmt2 = stmt2.stmt2
myData.stmt3 = stmt3.stmt3
myData.stmt4 = stmt4.stmt4
myData.stmt5 = stmt5.stmt5
myData.stmt6 = stmt6.stmt6
myData.stmt7 = stmt7.stmt7
myData.stmt8 = stmt8.stmt8
myData.stmt9 = stmt9.stmt9
myData.stmt10 = stmt10.stmt10
myData.stmt11 = stmt11.stmt11
myData.stmt12 = stmt12.stmt12
myData.stmt13 = stmt13.stmt13
myData.stmt14 = stmt14.stmt14
myData.stmt15 = stmt15.stmt15
myData.stmt16 = stmt16.stmt16
myData.stmt17 = stmt17.stmt17
myData.stmt18 = stmt18.stmt18
myData.stmt19 = stmt19.stmt19
myData.stmt20 = stmt20.stmt20
myData.comments1 = comments1.text
myData.sendAndLoad("insert2.asp",myData,"POST"); //asp
}
}
Response.charset="utf-8"
myData = new LoadVars()
myData.onLoad = function(){
if(this.writing=="Ok") {
gotoAndStop(2)
status.text = "Submited data was saved"
}
else status.text = "Error in saving submitted data"
}
stop()

-----------
This is the insert.asp page I am using:

<%
Option Explicit

Dim cn
Dim cmd
Dim rs
Dim stmt1, first_name, last_name, company, evaluators_role, years_known,
stmt2, stmt3, stmt4, stmt5, stmt6, stmt7, stmt8, stmt9, stmt10, stmt11, stmt12,
stmt13, stmt14, stmt15, stmt16, stmt17, stmt18, stmt19, stmt20, comments1

first_name = Request("first_name")
last_name = Request("last_name")
company = Request("company")
evaluators_role = Request("evaluators_role")
years_known = Request("years_known")
stmt1 = Request("stmt1")
stmt2 = Request("stmt2")
stmt3 = Request("stmt3")
stmt4 = Request("stmt4")
stmt5 = Request("stmt5")
stmt6 = Request("stmt6")
stmt7 = Request("stmt7")
stmt8 = Request("stmt8")
stmt9 = Request("stmt9")
stmt10 = Request("stmt10")
stmt11 = Request("stmt11")
stmt12 = Request("stmt12")
stmt13 = Request("stmt13")
stmt14 = Request("stmt14")
stmt15 = Request("stmt15")
stmt16 = Request("stmt16")
stmt17 = Request("stmt17")
stmt18 = Request("stmt18")
stmt19 = Request("stmt19")
stmt20 = Request("stmt20")
comments1 = Request("comments1")


Set cn = Server.CreateObject("ADODB.Connection")
cn.ConnectionString = "data_base"
cn.Open


Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = cn
cmd.CommandType = 1
cmd.CommandText = "Insert into data (first_name, last_name, company,
evaluators_role, years_known,stmt1, stmt2, stmt3, stmt4, stmt5, stmt6, stmt7,
stmt8, stmt9, stmt10, stmt11, stmt12, stmt13, stmt14, stmt15, stmt16, stmt17,
stmt18, stmt19, stmt20, comments1) values('" & first_name & "','" & last_name &
"','" & company & "','" & evaluators_role & "','" & years_known & "','" & stmt1
& "','" & stmt2 & "','" & stmt3 & "','" & stmt4 & "', '" & stmt5 & "', '" &
stmt6 & "', '" & stmt7 & "', '" & stmt8 & "', '" & stmt9 & "', '" & stmt10 &
"', '" & stmt11 & "', '" & stmt12 & "', '" & stmt13 & "', '" & stmt14 & "', '"
& stmt15 & "', '" & stmt16 & "', '" & stmt17 & "', '" & stmt18 & "', '" &
stmt19 & "', '" & stmt20 & "', '" & comments1 & "')"

Set rs = cmd.Execute

Response.Write "writing=Ok"
cn.Close()
Set cn = Nothing
Set cmd = Nothing
Set rs = Nothing
%>