Tony Weeg wrote: > XP - OS > USA My House - OS locale > SQL Server 2000 - RDBMS > No Idea? - database encoding > CFMX ODBC - driver > No Idea? - charset settings with your driver > CFMX? - template encoding > None. - usage of setEncoding() > None. - usage of cfprocessingdirective > None. - usage of cfcontent
Do you anticipate the need to store any characters that are not in 7 bit ASCII? > i cut and paste from a word doc to a text file. Did the word document have non-standard quotes (quotes that were differend from Asc(39))? > >From the text file, i cut and paste into cfmx page, form textareas > and inserted into database Text datatype fields. > > on first query i noticed every instance of the words "driver's > license" really looked like .... > > A driver or passenger who fails to wear a safety belt shall pay a $25 > fine. Court fees may not be applied to this provision. A violation of > this provision may not appear on a driver’s license, may not be > reported to an insurance company, and no points m.... > > obviously thats wrong. its supps to read driver's license. Both instances read the same to me. > anyway, if i run this query in query analyzer > > <cfquery name="get1" datasource="acts"> > select line, id from seatBeltLaws where line like '%’%' > </cfquery> > > i get 24 matching records, of which i would love to loop through and > use the udf Demoronize() from cflib.org to remove the crap, and insert 's DeMoronize() requires CF 5, so I would not be surprised if it was broken in CF MX. How about explicitly switching the charset of the page to UTF-8 using cfcontent? And ISO 8859-1? Jochem PS If this message looks garbled, make sure your mailclient interprets it as UTF-8. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
