Language setting problem

Forum|Forum|19 years ago
September 7, 2006
18 replies
1330 views

Hi,

I have an language setting problem about the forum. I wanna show Chinese characters in the forum. I have put the follow codes at in the beginning of every page:

<cfprocessingdirective pageencoding="big5">
<cfset setEncoding("URL", "big5")>
<cfset setEncoding("FORM", "big5")>

But it doesn't work. All the Chinese characters are shown as "???". I know there is another line of code may help:
<cfcontent type="text/html; charset=big5">

However, when I added the code to the pages, the header.cfm and footer.cfm page will not be shown (I used an index page to include the header, the content, and the footer by cfinclude) , and all the style cannot be applied.

Please help

FRANK

This topic has been closed for replies.

N

Newsgroup_User

Inspiring

?? wrote:
> <cfprocessingdirective pageencoding="big5">

on every page, yes.

> <cfcontent type="text/html; charset=big5">
> <cfset setEncoding("URL", "big5")>
> <cfset setEncoding("FORM", "big5")>

in the application.cfm (or equivalent), yes.

>
> still necessary?
>

A

Anonymous

Frank,

If you're still having problems with this, use:

<cfcontent type="text/html; charset=big5" reset="no">

If you don't set RESET, or set it to "yes", then it will discard all previous output before it...

N

Newsgroup_User

Inspiring

?? wrote:
> Someone told me that the characters become "???" after inporting the data to
> the database becoz my db use CHINESE_TAIWAN_STROKE_AI_CS which is a big5
> database and support 13000 chinese characters . But after importing to the host
> database, most of the character cannot be displayed coz it is an English db and
> support only 256 characters. Is that right?

no. that unicode test you took is on an en_US server. and i cast COLLATIONS all
the time depending on what language i need stuff sorted in.

肥

肥權84_2Author

Known Participant

And, are the codes

<cfprocessingdirective pageencoding="big5">
<cfcontent type="text/html; charset=big5">
<cfset setEncoding("URL", "big5")>
<cfset setEncoding("FORM", "big5")>

still necessary?

肥

肥權84_2Author

Known Participant

Someone told me that the characters become "???" after inporting the data to the database becoz my db use CHINESE_TAIWAN_STROKE_AI_CS which is a big5 database and support 13000 chinese characters . But after importing to the host database, most of the character cannot be displayed coz it is an English db and support only 256 characters. Is that right?

N

Newsgroup_User

Inspiring

?? wrote:
> The forum use storeprocedure and and cfqueryparam to insert datat. I dunno if
> it has turn on the unicode option for the datasource. How can I check it? I'm
> using big5 instead of unicode. Can the unicode option help?

go into cfadmin for that DSN & click on advanced options. you should see
"Enable Unicode for data sources configured for non-Latin characters",
turn that on.

肥

肥權84_2Author

Known Participant

The forum use storeprocedure and and cfqueryparam to insert datat. I dunno if it has turn on the unicode option for the datasource. How can I check it? I'm using big5 instead of unicode. Can the unicode option help?

I have make a mistake and it may misleading you: The data export from the testing db to the production db has no problem. I have just transfer the "???" from my db to the "host's db.

肥

肥權84_2Author

Known Participant

The forum use storeprocedure and and cfqueryparam to insert datat. I dunno if it has turn on the unicode option for the datasource. How can I check it? I'm using big5 instead of unicode. Can the unicode option help?

I have make a mistake and it may misleading you: The data export from the testing db to the production db has no problem. I have just transfer the "???" from my db to the "host's db.

N

Newsgroup_User

Inspiring

?? wrote:
> Sorry, I have just missed your post = P
>
> Most of the chinese characters I stored are using "nvarchar" datatype.
> However, the forum I purchased use "text" to store the data.

have to change to Ntext. how does the forum insert data? cfqueryparam (if so
make sure to turn on the unicode option for that dsn)? or it not, does it use
unicode hinting?

> I used the import wizard in MSSQL 2000 to transfer data from testing server to
> production server. Most of the chinese characters can be shown but a few
> columns which stores Chinese characters cannot be shown, only "???" can be
> displayed.

how are were those columns defined in the your db & in the host's db?

肥

肥權84_2Author

Known Participant

I bought the forum from this site
http://www.adersoftware.com/index.cfm?page=cfbb

肥

肥權84_2Author

Known Participant

The db driver i used should be Microsoft SQL Server