Hmmm - as a test I changed the collation on that column to SQL_polish_SP1250_CS_AS and to SQL_polish_SP1250_IS_AS
Both failed to save the characters again... hmmm.. stumped... -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:45 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] " Hmmm - I think it may be the collection on that ntext column." Sorry, collation, not collection. -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - I think it may be the collection on that ntext column. The problem is that I need to store western European AND polish chars in the same column. Can I do this when using the polish collation? -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hi Stephen, The characters are still there just before insert into the db. The db is SQL Server 2000. JDBC wouldn't do anything to it, would it? -----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 14:16 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich Wild wrote: >Ok - some more info on this: its not activedit, (sorry cfdev.com, my apologies) > >I replaced the activedit with a textarea and the same thing happened. So somewhere along the line my special chars are being replaced by the app or the DB. The db is a column of type ntext, and the app has <cfset setEncoding("form", "utf-8")> in the application.cfm > >Hmmm. > > Rich, Whats your db? I know mySQL needs additional connection strings to enable special characters and I think there are similar things for other databases. Are the special characters there if you output the form variable before you insert the content into the db? and all that debuggin jazz.... Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
