Tags: alli, collation, collations, communicate, database, latin1_general, microsoft, mysql, oracle, server, sql, sql_latin1_general, versus

SQL_Latin1_general collation versus Latin1_general

On Database » Microsoft SQL Server

1,361 words with 1 Comments; publish: Fri, 06 Jun 2008 11:53:00 GMT; (250125.00, « »)

Hi all!

I have 2 db with different collations (Latin1_general and SQL_Latin1_general

) that have to communicate...

is there any problems with these 2 collations? the queries made for a db

with SQL_Latin1_general can work in a db with Latin1_general collation?

the copy of data db1 into db2 does it work?

thanks!

All Comments

Leave a comment...

  • 1 Comments
    • The code will work, but you will see problems when you try to compare data

      from columns of different collations. See if the below helps:

      http://support.microsoft.com/default...b;en-us;322112

      Vyas, MVP (SQL Server)

      SQL Server Articles and Code Samples .sqlserver.todaysummary.com. http://vyaskn.tripod.com/

      "milly" <milly.sqlserver.todaysummary.com.discussions.microsoft.com> wrote in message

      news:62912E4F-2CDA-4BC8-9B20-2635A96ABF54.sqlserver.todaysummary.com.microsoft.com...

      > Hi all!

      > I have 2 db with different collations (Latin1_general and

      SQL_Latin1_general

      > ) that have to communicate...

      > is there any problems with these 2 collations? the queries made for a db

      > with SQL_Latin1_general can work in a db with Latin1_general collation?

      > the copy of data db1 into db2 does it work?

      > thanks!

      >

      #1; Fri, 06 Jun 2008 11:54:00 GMT