That was it, thanks for the help! I get so used to looking for the source of the problem in my code, completely forgot to see if it was an admin setting.
On Mon, Jul 5, 2010 at 2:03 PM, Paul Alkema <[email protected]>wrote: > > 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:335088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
