How are you storing the text in the database?
When we added multilingual support, all we had to do to SQL Server was:
* Change any char/varchar/text to their double-byte counterparts
(ntext etc).
* Ensured that all queries uses cfqueryparam
* Set some setting in the SQL Server JDBC driver... I'd tell you
what the checkbox is labeled, but our dev server seems down. It's
something to do with passing strings as-is or something like that.
Following this, everything was just peachy. CF by default uses UTF8, and
that meant that we could even mix different languages on the same page.
Anyway, getting back to your problem, maybe try having a look at the
response headers your browser is getting? Maybe there's conflicting
information there.
Ryan Sabir wrote:
> Hmmm,
>
> Not quite sure how cfprocessingdirective is supposed to work. Does
> this mean the text in my .cfm document should be in a different
> encoding? If so then this is not the case, as all text in the site
> comes from a database.
>
> The strange thing is when I look at the site:
> http://www.miller.com.au/index.cfm?&setlanguage=2
> <http://www.miller.com.au/index.cfm?&setlanguage=2>
>
> The Chinese characters look like garbage. If I manually change the
> page encoding to Simplified Chinese (gb2312) it looks fine.
>
> If I then add the line:
> <cfcontent type="text/html; charset=gb2312">
>
> The page still looks like garbage, but a different set of garbage.
> Strange thing is, now the page encoding in my browser is set to
> Simplified Chinese (gb2312), even thought its not displaying as such.
>
> This all worked fine in CF5, whats the trick to getting it to work in CF7?
>
> thanks.
>
>
> ------------------------------------------------------------------------
> *From:* cfaussie@googlegroups.com
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Haikal Saadh
> *Sent:* Thursday, 14 September 2006 5:42 PM
> *To:* cfaussie@googlegroups.com
> *Subject:* [cfaussie] Re: Simplified Chinese encoding
>
> Not using UTF8?
>
>> Reading a ColdFusion page with a nondefault character encoding
>> Macromedia recommends that you encode all international
>> application pages as UTF-8 with a byte-order mark (BOM), so that
>> ColdFusion automatically detects the page as UTF-8 encoded; no
>> |cfprocessingdirective| tag is needed. The BOM sets the first
>> byte of a UTF file, so the program reading the page recognizes
>> which encoding is in use.
>>
>> If this is not possible, to specify that ColdFusion reads a page
>> with a character encoding other than the Java default locale
>> value, you use the |cfprocessingdirective| tag and |pageencoding|
>> attribute, as follows:
>>
>> <cfprocessingdirective pageencoding=" |encoding| ">
>>
>> Typically, you assign one of the following values to |encoding| :
>>
>> EUC-JP (Japanese)
>> EUC-KR (Korean)
>> ISO-8859-1 (Western European and English)
>> SHIFT_JIS (Japanese)
>> UTF-8 (All Languages)
>>
>
>
>
> from
>
> http://www.adobe.com/support/coldfusion/internationalization/internationalization_cfmx/internationalization_cfmx3.html
>
>
>
> Ryan Sabir wrote:
>> Hey all,
>>
>> I'm trying to get some web pages to show in Simplfied Chinese
>> encoding, but the standard META tag doesn't seem to be working.
>>
>> When I look at this page:
>> http://www.miller.com.au/index.cfm?&setlanguage=2
>> <http://www.miller.com.au/index.cfm?&setlanguage=2>
>>
>> All the chinese characters are coming up wrong, however, when I
>> go to the View->Encoding menu and manually set the encoding to
>> gb2312, it looks fine.
>>
>> I have the
>> <meta http-equiv="content-type" content="text/html; charset=gb2312">
>>
>> line in there which is supposed to set the character encoding,
>> but my browser is defaulting to Unicode.
>>
>> This only started happenning when it moved from III5 on Win 2000
>> Server to IIS6 on Win 2003 Server. Is there a server setting I
>> need to tweak to enable this?
>>
>> thanks.
>>
>>
>>
>>
>> Ryan Sabir
>> Technical Director
>>
>> *p:* (02) 9274 8030
>> *f:* (02) 9274 8099
>> *m:* 0411 512 454
>> *w:* www.newgency.com <http://www.newgency.com/>
>> *Newgency Pty Ltd*
>> Web | Multimedia | eMarketing
>>
>> 224 Riley St
>> Surry Hills NSW 2010
>> Sydney, Australia
>>
>>
>>
>>
>
> --
> Haikal Saadh
> Applications Programmer
> ICT Resources, TALSS
> QUT Kelvin Grove
>
>
>
> >
--
Haikal Saadh
Applications Programmer
ICT Resources, TALSS
QUT Kelvin Grove
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
