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]
