Hi, What's your data type for the sql column that your trying to insert this data into? If your inserting Unicode characters into varchar column you should change the datatype to nvarchar.
Also, when using unicode in ColdFusion with cfqueryparam's I would confirm that "String Format" is checked in your ColdFusion administrator. It should be noted however that if this is enabled for your main dsn that it could possibly cause performance issues. I have two datasources one called nMainDns and another called mainDns. The nMainDns is used to insert Unicode statements while using cfqueryparam's while the other is used for select statements or stored procedures. Paul Alkema http://paulalkema.com/ On Mon, Jul 5, 2010 at 1:40 PM, Pete Ruckelshaus <[email protected]>wrote: > > 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:335065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
