Change character set

[xfile]

Hi,

We have boiled down to the possible cause of these two line:

Body = Body & CR & Itemname & CR
Body = Body & getlang("LangProductQuantity") & ": " & RSItems("numitems")
& CR

They are retrived from DB, any way to change these two a different character
set?

Many thanks.

 

[Kevin Spencer]

I'm so confused!

Could you try again, please? Perhaps a bit more information would be
helpful.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

 

[xfile]

Ha Ha Ha,

I am so confused too.

This is how it works.

There is so-called "control" which will be inserted into the HTML e-mail
template that is going to send out after an order is being placed.

The e-mail template and the e-mail components work fine when sending out
messages with different chracters except for those data inserted by these
controls.

We looked those controls, for example, such as the following one:

Select Case keyword
Case "ADD_OITEMS"
Handle_OITEMS value, parsearray,parseRS
rc=0


And then it has the following....

Dim Isql, deliveryaddress, deliveryarray
dim orderid
Dim rsitems
Dim Dbc, recordid
Dim CR, itemname
recordid=parsearray(pidvalue)
If ucase(Getsess("emailformat"))="HTML" then
CR="<br>"
else
CR = GetMailCR
end if
'OpenOrderdb dbc
isql="select * from oitems where orderid="
If Getsess("oid")<>"" then......

..........................
........................... until the final ones like the following ----

Body = Body & CR & Itemname & CR
Body = Body & getlang("LangProductQuantity") & ": " & RSItems("numitems")
& CR

end if
RSItems.MoveNext
Loop
rsitems.close
Set rsitems=nothing
end sub

------------------------------


In any case, Itemname is the product description, and LangProductQuantity is
the caption of Product Quantity field in the language tables which is using
a different characters.

Now the problem is both product description and Product Quantity cannot be
properly encoded with correct character set while the rest of email messages
can.

Again, only those from these so-called "controls" cannot display proper
character set.

We have tried almost everything we know but still unable to solve this.

Again, everything else is fine except those from this control, so we believe
it should have something with the BODY.

Many thanks if anyone can help.

 

[Kevin Spencer]

What database are you using? You're having a problem with your database
data, which is in a certain character set. While it may be possible, if the
database is storing the data in Unicode, to translate the data into a
different character set, it may not be possible using ASP (I just don't
know, but I doubt it). Using SQL Server and ASP.Net, you could probably
solve this issue.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

 

[xfile]

Hi,

We are using SQL 2000 and the database problem has been solved and it is
working fine.

The cause of the problem, now as we have learned but have not fully tested
yet, is the application design for which it does not put proper character
set into it.

Even we have made the email components parts and the message template part
right, it didn't work that way.

According to the vendor, it fixed the problem is the mail setting part of
its application. We have received a few sample messages with correct
characters but yet to commence a full test.

If it is being confirmed, it is then possible to transfer the database (with
Unicode settings) to ASP files. I could confirm this as well because we
have done it although using simple ASP forms.

Many thanks for your kind help.