Trouble with international characters

[Pete Ruckelshaus]

I am using CF to import data from an Excel spreadsheet to an MS SQL Server
2005 database.  Salient points: Characters are showing properly in the .XLSX
file; text fields in the SQL server database are all nvarchar or ntext; I am
using <cfprocessingdirective pageencoding="UTF-8" /> at the top of the page
that is processing this page; and, finally, I am using <cfspreadsheet> to
read the spreadsheet and put it into a query object.  Here's the data
processing code:

<cffile action="UPLOAD" destination="#getTempDirectory()#"
filefield="uploadxls" nameconflict="MAKEUNIQUE">

<cfspreadsheet action="read"
src="#cffile.serverdirectory#\#cffile.serverfile#" sheetname="sheet1"
query="getData">

<cfloop query="getdata" startrow="1" endrow="1">
 <cfset workingset =
queryNew("#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#","varchar,varchar,varchar,varchar")>
 <cfset workingset_col1 = getdata.col_1>
 <cfset workingset_col2 = getdata.col_2>
 <cfset workingset_col3 = getdata.col_3>
 <cfset workingset_col4 = getdata.col_4>
</cfloop>
<cfloop query="getdata" startrow="2">
 <cfset t1 = queryAddRow(workingset)>
 <cfset t1 = querySetCell(workingset, workingset_col1,
stripOuterQuotes(getdata.col_1))>
 <cfset t1 = querySetCell(workingset, workingset_col2,
stripOuterQuotes(getdata.col_2))>
 <cfset t1 = querySetCell(workingset, workingset_col3,
stripOuterQuotes(getdata.col_3))>
 <cfset t1 = querySetCell(workingset, workingset_col4,
stripOuterQuotes(getdata.col_4))>
</cfloop>
<hr />
<cfquery name="workingset" dbtype="query">
 SELECT name, description, latitude, longitude
 FROM workingset
 ORDER BY name
</cfquery>

Now, the problem that I am having is that SOME (and not all) of the
international characters are not showing up properly.  For instance:

These show up properly:
Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, Terezín

These do NOT show up properly (correct versions in parentheses):
Brn?nec (Brněnec)
Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
Che?mno Extermination Camp - (Chełmno Extermination Camp)
Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo) Concentration
Camp)

In case you're curious, I teach high school English and am working on a
Holocaust Location mapping project for my Holocaust Literature class.

Does anyone have any ideas as to why some international characters are
making it through just fine, but others are getting munched?  This is really
the first time I've worked with anything beyond the basic Latin character
set.

Thanks,

Pete


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm