My suggestion would be..... nonsense
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] what does the N stand for? "Rich Wild" <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> group.com> cc: Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] 14/07/2004 11:13 Please respond to dev You'll all be overjoyed no doubt to learn that I've discovered the problem. So for those of you interested: On my insert, in the SQL syntax, rather than INSERT INTO dbTable(content) VALUES('#content#') It should be: INSERT INTO dbTable(content) VALUES(N'#content#') (Note the N) I can't find any SQL BOL info on that - can anyone find it? I presume it tells SQL Server to expect Unicode data and so not to perform any translation on the characters? This means that the collation on the column and database can remain on my default Latin (western European) and I can store whatever character set I like in there, confusingly. -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 09:36 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Cheers Gene, yea that works for me too. Problem is, I'm worried about having Polish as the database default when I'm not just storing Polish content, I'm storing X number of other languages as well. Its strange we have a database containing Chinese characters using a Latin collation, both as database default AND column collation. I can't figure it out. -----Original Message----- From: Gene Brown [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 17:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] 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] -- 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]
