New answers tagged collation
You have to change the collation settings either in your queries or in SSAS. There are several different options so the important question is do you use SSAS for other databases than the Croatian_CI_AS one. If so you can pepper all your queries with collate Latin1_General_CI_AS to make sure that you get the data in the Latin1 collation into the cubes. If ...
The datcollate column of pg_database stores LC_COLLATE for this database An other page of the documentation about collations says: The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. This alleviates the restriction that the LC_COLLATE and LC_CTYPE settings of ...
You use the collate operator in the join. Such as: select <column list> from dbo.firsttable f join linkedserver.database.dbo.secondtable d on f.name collate database_default = d.name collate database_default Of course, you can also specify a specific collation, such as: SQL_Latin1_General_CP1_CI_AI
I think the question as stated (on 2015-04-20, "Which collation [...]") is not what is meant, given that the accepted answer talks about encoding rather than collation. Let me answer the stated question rather than the intended one, just because I think it is interesting :-) Wikipedia says "Collation is the assembly of written information into a standard ...
Top 50 recent answers are included