Patric Stumpe wrote: > That whole hosting thing has become some kinda political beyond my > recommendations. Really difficult. So I have to stick with what's > given on the server side. You won't believe how happy I was when I > heard that I was *allowed* to port the DB...
well it would really help to know if they are actually forcing utf-8 or whatever as file encoding. make some sense of your problems. > WHERE adate >= CreateODBCDate(now()) > AND sdate <= CreateODBCDate(now()) CreateODBCDate is redundant. > And those title and shorttext contents get screwed as long as I use > the upper DateFormat. Setting the date vars manually (for testing) which is kind of overkill, why not use day/month/year functions instead? the 0 padding? > everything works fine (or - as discovered - using LSDateFormat() > without setting a setLocale() in App.cfm). it might be because of either the file encoding forced to utf-8 (low odds?) or dateformat on a "localized" OS is producing UTF-8 which gets mixed in w/the rest of the latin-1 text stream & breaks. also are you sure the text from the db is latin-1? maybe windows-1252? that's a superset of latin-1 & can cause some interesting side effects if used as if it were latin-1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
