> > I am beginning to run into the same thing... Im running MX enterprise with > > SQL 2000 and half the time my data type 'text' inputs start adding funky > > symbols for quotes, ticks, and hyphens but not in a eaisly determined > > pattern.. > > This is what we need to know: > - what database SQL 2000 Enterprise
> - how was the data inserted into the database (charset) Default i dont change that.. should i rethink that idea > - what database driver MERANT SQL for Unix (Shipped with CFMX) > - what fieldtypes text.. those are pretty much all that have long enough strings to need '/"/- 's > - which of the following are used and in which way: > - cfcontent Not > - cfprocessingdirective Not > - setEncoding() Not > - what charset is your content supposed to be YES... whatever worked with 5 > - what locale are the servers English (US) hmm ill have to look into internationalizing... bust shouldnt MX assume based on install the servers locale? or is that an incorrect assumption on my behalf. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
