Ah crap I totally forgot about that... > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 14 July 2004 11:13 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] > > 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]
