Oh, and here's the code for my SQL that's inserting the data: <cfquery name="insertRecords" datasource="holocaustlearning"> INSERT INTO tblHLMapLocations(name, description, latitude, longitude, locationIsApproximate, active) VALUES (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#trim( workingset.name)#">, <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#stripHTML(trim(workingset.description))#">, #trim(workingset.latitude)#, #trim(workingset.longitude)#, <cfqueryparam cfsqltype="CF_SQL_BIT" value="#locationIsApproximate(workingset.description)#">, <cfqueryparam cfsqltype="CF_SQL_BIT" value="false">); </cfquery>
2010/7/5 Pete Ruckelshaus <[email protected]> > 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:335064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
