Collation Problem

[guy]

I have a sql server 2000 database and have pasted data from notepad into it,
the notepad file is ascii, and looks fine under the binary editor. the data
in the table appears correct.
however when an attempt is made to read the data i get a message:-
Cannot resolve collation conflict for column 2 in SELECT statement.

column 1 is int, the all other columns are nvarchar

any ideas?

[guy]

RE: Collation Problem

further to the above if i change the nvarchar columns to varchar, when i run
the app i get:-
"Implicit conversion of varchar value to varchar cannot be performed because
the collation of the value is unresolved due to a collation conflict."


"guy" wrote:
[color=blue]
> I have a sql server 2000 database and have pasted data from notepad into it,
> the notepad file is ascii, and looks fine under the binary editor. the data
> in the table appears correct.
> however when an attempt is made to read the data i get a message:-
> Cannot resolve collation conflict for column 2 in SELECT statement.
>
> column 1 is int, the all other columns are nvarchar
>
> any ideas?[/color]

[guy]

RE: Collation Problem

fixed by changing the collation from <database default> to Latin1_General_ CI_AS

why was this neccessary though?


"guy" wrote:
[color=blue]
> further to the above if i change the nvarchar columns to varchar, when i run
> the app i get:-
> "Implicit conversion of varchar value to varchar cannot be performed because
> the collation of the value is unresolved due to a collation conflict."
>
>
> "guy" wrote:
>[color=green]
> > I have a sql server 2000 database and have pasted data from notepad into it,
> > the notepad file is ascii, and looks fine under the binary editor. the data
> > in the table appears correct.
> > however when an attempt is made to read the data i get a message:-
> > Cannot resolve collation conflict for column 2 in SELECT statement.
> >
> > column 1 is int, the all other columns are nvarchar
> >
> > any ideas?[/color][/color]