Rich, What collation did you select when creating the database?
I have just been through your process, selecting "polish_CS_AS_KS_WS" as the collation for the database. The queries then work with the correct characters being added and retrieved from the db. Cheers Gene -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 17:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Ok - I did the following: New database New table ('test' - columns: line_id NUMERIC IDENTITY, content NTEXT) INSERT INTO test(content) VALUES('Znajdą Państwo Zachęcamy') SELECT content FROM test Results: ' Znajda Panstwo Zachecamy ' (ie, lost all the special chars.) This was all in Query Analyser. -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:44 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Have u tried, make a new database, create a new table, set the coalition and ntext, try the insert.. At least u will know if it's just that database being silly then. > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 16:31 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] > > Via query analyzer I can insert Chinese text into the first > table, but not the second (well, it goes in, but it doesn't > come out chinese) > > Both columns are ntext, default collation > > Both collations are the same for both databases. > > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 16:27 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] > > 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] > > > > > -- > 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]
