some Chinese characters can't display in the website

[creazyfeng]

We use CF7.0,and use sqlserver2000 as database,but in my website some chinese
characters can't display correctly ,just display "?" or other letters ,but
most of the infomation described with chinese characters can display
exactly,why?

[PaulH *ACE*]

creazyfeng wrote:

> We use CF7.0,and use sqlserver2000 as database,but in my website some chinese
> characters can't display correctly ,just display "?" or other letters ,but
> most of the infomation described with chinese characters can display
> exactly,why?

what "kind" of chinese? what db driver? what datatype are you using to store the
text? how was the text entered into the bd? what encoding on the cf page?

[creazyfeng]

simplified Chinese ,Microsoft SQL Server ,varchar,
note::the Chinese character which can't display in the website can be stored and display correctly in the database !!

[BKBK]

Make sure your web pages have UTF-8 encoding (charset).

[PaulH *ACE*]

creazyfeng wrote:

> simplified Chinese ,Microsoft SQL Server ,varchar,
> note::the Chinese character which can't display in the website can be stored and display correctly in the database !!

ok, i guess that means the JDBC one which is ok, BAD! and the rest of my
questions? "how was the text entered into the db? what encoding on the cf page?"
i guess i might wistfully add "what encoding did you want to use for your data?".

to short cut this, you need to be storing your data in the "N" data types. the
fact that your db can store & display *anything* is completely irrelevant to
your issue. as varchar data, it gets mangled going in & the mangled on the way
out & only the mangling s/w knows how this was done. ignore that & concentrate
on what's happening w/cf & JDBC. fix the datatype, export & re-import the data.

[PaulH *TMM*]

this might also help:
[url]http://www.sustainablegis.com/unicode/greekTest.cfm[/url]