5 Replies Latest reply on Apr 28, 2008 3:26 AM by Newsgroup_User

    Unable to Send mail in Korea, Traditional Chinese and Thai

    munmun77
      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.
        • 1. Re: Unable to use mail in Korea, Traditional Chinese and   Thai
          Level 7
          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?
          • 2. Re: Unable to Send mail in Korea, Traditional Chinese and Thai
            munmun77 Level 1
            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.
            • 3. Re: Unable to Send mail in Korea, Traditional Chinese   and Thai
              Level 7
              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.
              • 4. Re: Unable to Send mail in Korea, Traditional Chinese and Thai
                munmun77 Level 1
                > 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.
                • 5. Re: Unable to Send mail in Korea, Traditional Chinese   and Thai
                  Level 7
                  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?