Re: Change character set
- From: "xfile" <cou-cou@xxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Aug 2005 10:06:41 +0800
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.
"Kevin Spencer" <kevin@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23bvrowOnFHA.1088@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <cou-cou@xxxxxxxxxxxxxxxxx> wrote in message
> news:OvscJyNnFHA.3608@xxxxxxxxxxxxxxxxxxxxxxx
>> 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" <kevin@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:eYeJwmNnFHA.2852@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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" <cou-cou@xxxxxxxxxxxxxxxxx> wrote in message
>>> news:%2315Wy9MnFHA.2180@xxxxxxxxxxxxxxxxxxxxxxx
>>>> 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.
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
.
- References:
- Change character set
- From: xfile
- Re: Change character set
- From: Kevin Spencer
- Re: Change character set
- From: xfile
- Re: Change character set
- From: Kevin Spencer
- Change character set
- Prev by Date: Re: Frontpage 2000 / CSS / Hosted on Windows 2003
- Next by Date: web server
- Previous by thread: Re: Change character set
- Next by thread: A hyperlink back to my home page won't work
- Index(es):
Relevant Pages
|
