Japanese text -SQL Server to Email - jmail

[puitar]

Hello,

I have a SQL 2000 database that is configured to store japanese text.

I am able to input via a form and output via asp japanese text successfully from the database.

I am having problems using this japanese data to create dynamic emails using jmail version 3.7.0.

Whenever I send japanese text in an email the text is displayed as ????????(questions marks)

I have the correct language packs installed and the database is fine.

My code is below..


set tConnection = server.CreateObject("ADODB.Connection&quot
tConnection.Open "driver={SQL Server};server=sgsdfh2;uid=dfsh;pwd=dfsh;database=dfshdfs;"
tSQLStr = "select * from logins"

set rs = tConnection.Execute(tSQLStr)

dim japtext
japtext = rs("Login&quot

rs.close
tconnection.Close

'send email

set objJMail = Server.CreateObject("JMail.SMTPMail&quot
objJMail.ServerAddress = "gffjfjfj"

objjmail.Charset="utf-8"
'objjmail.Charset="iso-2022-jp"
'objjmail.Encoding="uuencode"
objjmail.ContentTransferEncoding = "8bit"
objjmail.ContentType = "text-html;"
objjmail.HTMLBody = japtext
'objJMail.Body = japtext
objJMail.AddRecipient("cvcfds&quot
objJMail.Sender = "fgfgjfgj"
objJMail.Subject = "Test"

objJMail.Execute

set objJMail = nothing


Help anyone??

 

[puitar]

I found a solution.

I needed jmail version 4. I had jmail version 3.7 which did not fully support internationalisation.