Can u insert the same text into both database via query analyser? Or does it only fail on the polish one. Check the coalition setting of the DATABASE properties for both databases (not just the tables) and see what the default is set to.
> -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 16:17 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] > > Hmmm - more information. > > I have 2 databases on the *same* sql server. > > One has a table with an ntext column, default collation, that > contains Chinese characters > > The other has a table with an ntext column, default > collation. Ie identical. > > How come one can contain Chinese characters, but when (in > Query Analyser, so not through CF at all) I insert those > characters (through a cut and pasting from a select on the > chinese table) into my other column, and then select, I get > nothing out but gibberish characters? > > I'm very confused. They *can't* be identical! There must be > something different between the two. > > Just what the hell is it? > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 15:42 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] > > 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] > > > > > -- > 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]
