Unable to Send mail in Korea, Traditional Chinese and Thai

Report · Apr 24, 2008

Hi,

I have just started using CF 8.
I have trying to send email using CFMAIL. The content of the email consist either Korea or Traditional Chinese or Thai characters. But the characters are not displaying in the email.

I actually retreive the data from database and display on the website. It is displaying properly with the charset the I used. But only in email, it can't display properly.

Pls help!

Thank you.

Report · Apr 25, 2008

munmun77 wrote:
> I actually retreive the data from database and display on the website. It is
> displaying properly with the charset the I used. But only in email, it can't
> display properly.

first off what does "can't display properly" mean?

i just tried something like your code w/unicode (utf-8) & it worked fine. a few
things:

with such different languages i'm kind of surprised you're not using unicode for
your app's encoding, save lots of headaches.

as a matter of good practice you should always include

<cfprocessingdirective pageencoding="big5">

> <html>
> <head>
> <title>Untitled</title>
> </head>
> <meta http-equiv="Content-Type" content="text/html; charset=big5">

shouldn't this be in the header tags?

> <body>
> <cfheader
> charset="big5"
> name = "content-type"
> value = "text/html;">
>
> <CFQUERY name="GetScreen_Login" dataSource="VOCTEST">
> SELECT *
> FROM VC_SCREEN_STR
> WHERE STR_no = 2
> </CFQUERY>
>
> <cfoutput>
> #GetScreen_Login.STR_FXTW#
> </cfoutput>
>
> <CFMAIL TO="Serene.Chua@fujixerox.com"
> FROM="EMSSAdmin@fujixerox.com"
> SUBJECT="Test Email"
> charset="big5"
> TYPE="HTML">
>
> <cfmailpart type="html" charset="big5">
> <html>
> <head>
> <title>EMAIL</title>
> </head>
> <body>
> <meta http-equiv="content-type" content="text/html; charset=big5">

shouldn't this be in the header tags?
>
> <cfheader
> charset="big5"
> name = "content-type"
> value = "text/html;">

not sure where cf would stuff this? email or the current page? i would maybe
just stick w/the plain HTML meta-header for the email.

> <cfoutput>
> #GetScreen_Login.STR_FXTW#
> </cfoutput>
> </body>
> </html>
> </cfmailpart>
> </cfmail>
>
> <CFHEADER NAME="Expires" VALUE="#Now()#">

not exactly sure the effect of *not* adding charset to this tag but probably a
good idea....

does plain email work? can you send me an example email?

Report · Apr 27, 2008

hi,

I am actually new to CF 8. Was using CF 5 earlier.

This is my first time trying to send email in other language.

I actually have some Traditional Chinese characters saved in database. I am trying to retrieve the characters and send out in an email. But the Traditional Chinese characters are not displaying properly in the email.

But when I try to display the Traditional Chinese characters on the brower, it is displaying properly.

Below is what it is showing in the email:
±??v??￥? / Authorized User Only

It should display as : 授權使用 / Authorized User Only

Thank you.

Report · Apr 28, 2008

munmun77 wrote:
> I am actually new to CF 8. Was using CF 5 earlier.

and was the chinese, etc. data entered via cf5?

> This is my first time trying to send email in other language.

it's actually fairly simple, just make sure the encoding back to front is the
same (and that applies to pretty much any i18n cf work).

> I actually have some Traditional Chinese characters saved in database. I am
> trying to retrieve the characters and send out in an email. But the Traditional
> Chinese characters are not displaying properly in the email.

does plain text email work? what about static text in an email? again, can you
send me an example email?

> Below is what it is showing in the email:
> ???v???? / Authorized User Only

looks like an encoding snafu.

Report · Apr 28, 2008

> I am actually new to CF 8. Was using CF 5 earlier.

and was the chinese, etc. data entered via cf5?
[munmun77] Yes.

> This is my first time trying to send email in other language.

it's actually fairly simple, just make sure the encoding back to front is the same (and that applies to pretty much any i18n cf work).

> I actually have some Traditional Chinese characters saved in database. I am
> trying to retrieve the characters and send out in an email. But the Traditional
> Chinese characters are not displaying properly in the email.

does plain text email work? what about static text in an email? again, can you
send me an example email?

Ok, will send u an sample.

> Below is what it is showing in the email:
> ???v???? / Authorized User Only

looks like an encoding snafu.

Report · Apr 28, 2008

munmun77 wrote:
>> I am actually new to CF 8. Was using CF 5 earlier.
>
> and was the chinese, etc. data entered via cf5?
> [munmun77] Yes.

that could be the real problem.

build another simple table, use the JDBC driver (i think it should just be
labeled "oracle") & try inserting some big5 or unicode data via cf. can you
email that? can you display that ok?

Adobe Community

Unable to Send mail in Korea, Traditional Chinese and Thai