But I'm just using a simple cfquery to insert straight into the table and the column is ntext and the collation is now polish, and the datasource has been configured to use Unicode.
I'm utterly stumped! -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] I've had this problem with chinese and sql server. It was the tmp table used in a stored procedure, the column in the tmp table was not ntext (so it was losing the formatting) within the stored procedure It's worth a look... Mark -----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] (not) activedit and polish chars[Scanned] >Someone else out there must be storing non-western alphabet in sql >server? > > I do.... just not in SQL Server - it was dead simple with mySQL. All I had to do was add the following to the connection string. useUnicode=true&characterEncoding=ISO8859_1 Everything worked without additional help after that. 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]
