Thanks Mark. Nothing really there that's resolved the issue, but I appreciate it, ta.
This is weird. I've discovered another app here developed before I arrived that sends out Chinese character emails. The collation on that table is the default (latin), but the datasource is configured for non-western alphabet. I've restored the collation on my table to the same (database default - latin) but still no dice. It'd be fine if I wasn't racing deadlines. Gah. -----Original Message----- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Weird The only other time I have had trouble with SQl Server and languages is when character sets used within SQL Server were playing up. This caused me a big problem a couple of years ago with SQL Server 7, but I thought it was resolved with 2000. That's the only other thing which springs to mind Mark http://www.databasejournal.com/features/mssql/article.phpr/1587631 This article talks about the problem I encountered, but also mentions collation at column level -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 15:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] 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] -- 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]
