November 4, 2008 at 11:15 am
hello
I am trying to Concatenate two fields within the same table to give me a new column, but when i run the query get the following error message:
Msg 451, Level 16, State 1, Line 2
Cannot resolve collation conflict for column 35 in SELECT statement.
Does anyone know why?
November 4, 2008 at 11:29 am
The two fields have different collations is all I can come up with not having the DL for the table. Script the create statement for the table and look at the collation for each of the columns.
You may want to post the DDL if you want addtional help.
November 5, 2008 at 3:01 am
Hiya
I checked it as you advised, and found that they had different collations, is there a way around this with changing it from the engine but within my query?
[FitID] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,
[SizeID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
November 6, 2008 at 9:58 am
I tried to recreate your problem based on the information given and it concatenates the columns without error.
You'll need to post the DDL so prople can understand the problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply