.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Collation Differences?

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Our company's standard collation for all new servers and subsequent databases is SQL_Latin1_General_CI_AS.  We purchased a 3rd party software package that creates a database using the collation Latin1_General_CI_AS.  From the little information I could find on the web and books online, they seem to be the same in definition of specification; however, when joining tables from our downstream databases to the 3rd party database tables we encounter collation errors.  Our DBA insists there is no difference between the two, but the 3rd party company has informed us that their product is only certified on the collation installed and, if we change the collation, they will no longer support the product if we have a problem them deem is related to the non-certified collation.  Where can I definitively ascertain information about whether the application will behave differently under our default collation and preclude us from using it.  Thanks in advance.

View Complete Post

More Related Resource Links

what's the right collation for sql server 2008 to ignore french accent?

I want to  sql server 2008 collation using english as default(in Canada). when search for text, french accent can be ignore. For example, À,Â,Ä, à, â, ä will be treated same as a or A, but the data still is stored as different(such as for key). so what is the right collation need to be selected when install sql server 2008?. If existing instance collation is not the right one, how to change it to the right one?

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

Server Collation SQL_Latin1_General_CP1_CI_AS versus Latin1_General_CI_AS

Hi,Why does SQL Server 2005 sometimes install with a server collation of :Server Collation SQL_Latin1_General_CP1_CI_AS and other times a server collation of :Latin1_General_CI_ASWhat causes this ???What is the difference between the two ?Are there any problems restoring databases from one to the other ? Do the two different collations cause problems with applications ?

WorkflowApplication Methods Differences?

Can any one explain what the difference is between the following methods of WorkflowApplication: Abort Cancel Terminate

How to handle differences in HTML code from different browser versions?

First of all I'm still very new to C# so be gentle :p I'm currently trying to make an application that can login to a certain website and search for some numbers and so on that I can put in an overview, just to save some time. The only thing I found that could do this is the WebBrowser control, and I've managed to make it work, but when I gave the program to a friend it failed. I think it has to do with the difference in browser versions (he uses Internet Explorer 7, I use the latest) and if that's the case I'm pretty clueless how to deal with the problem, since I don't even know what the differences in HTML codes are in each version, and it seems like a lot of work to adjust all the html code to check for accordingly. For example it was even so that & changed to & in my application on my PC and that's only by using one browser so I dunno what happens with other browser versions. I assume that the WebBrowser control always uses Internet Explorer, even if for example Firefox is the standard browser, is this true? But to be sure I asked the friend to put his Internet Explorer as the default browser and still no go. So my question is: is there a relatively easy way to make sure that the program works on practically any PC, without me having to make exceptions for like version 1.6.7 or 1.6.8 (I have no idea what versions there are really)?

Create Statement and Collation

I have DTS which includes a step to create table: CREATE TABLE [contracts] (             [ContractId] [varchar] (10) NOT NULL ,             [ClientId] [varchar] (10)   NOT NULL ,             [contract_nm] [varchar] (50)  NULL ,             [CreditLimit] [money] NOT NULL ,             [prod_cd] [varchar] (2)  NOT NULL ,             [DateOpened] [datetime]  NOT NULL ,             [interestfree_period] [int] NOT NULL ,             [DateFirstPayment] [datetime] NULL , … However, if I examine the table using sp_help after it is created the ContractId field has collation specified against it. [ContractId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , Why is collation specified against the ContractId field when I have not specified it in the create statement in the DTS? Thanks in advanceA SQL Server DBA Wannabe

Persian Collation problem

hi. i am using sql server 2008 and i have a database with Persian_100_CS_AS collation. i chosed this collation to store persian dates. it works correctly for most dates (such as 1370-05-02 , 1370-02-01) but for some persian dates (such as 1370-02-30 , ) does not ! when ever i try to insert such values the following messeage were shown. "the changed value in this cell was not recognized as valid .net framework Data Type:DataTime". any ideas? thanks in advance.    

Clustered vs NC index storage differences?

Does clustered index takes more disk space than NC for the same filed(s) for large tables? Also is CI takes longer (time) to build than NC if you have large tables? Any microsoft articles supporting these aruguments.

Differences between Silverlight and WCF(Full Framework) drawning

I have created a "Layout Editor" in Silverlight where the user can drag and drop text and image to create a custom layout. A sample of a Layout with one TextBlock can be seen here . The used font is Arial, size 50. This layout (not the image, but the layout itens properties like x,y,font, etc) is upload to the server by a WCF Service, which create the actual image and save it in the database. This is necessary because the text fields can have dynamic text, marked as '%text1', '%text2', where that dynamic values are in the database too. But, when i use the Bitmap and Graphics classes of the full .NET framework the DrawString method resulting drawning don't have the same aspect that your silverlight "counterpart". A result of the server generate image can ben seen here . Anyone can tell me if it is a resolution problem or something? I can't got a single clue about this.   PS: If it is possible, move to the corresponding forum section. I use Silverlight UI, WCF communication and GDI+ drawning, so used WCF forum.    

Collation SQL 2005 sql_latin1_general_cp1_ci_as

Hi, Our application uses SQL 2005 database with Latin1_General_CI_AS as collation. There are nearly a million records in this database. I need to move my data to another SQL 2005 server which has 'SQL_Latin1_General_CP1_CI_AS ' as collation. I know there would be lots of issues. Do you know what are the likely issues that we would face. Since there are lots of modules dependent on this database, it would be difficult to test each and every component if all works ok or not. Is this advisable to move to another database with this non standard SQL_Latin1_General_CP1_CI_AS  collation?   thanks sANDY  

Database differences 2008 R2 editions

I am running 2008 R2 standard and a client wants to move from 2005 to 2008 R2 Enterprise. Will I be able to download a database from their system and restore it to my system? Assuming there are no components/coding in use on the Enterprise version that are explicitly reserved for Enterprise?  Maybe I should ask, is there a fundamental incompatibility right out of the box between the databases from these two editions like when attempting to restore an 2008 database on a previous version instance?  I hope I asked that right :)

Replication Collation

I have two servers with different collations. I perfer having all databases on the server to have the same collation. I am using transactional replication to replicate a database from server A(collation1)  to server B (collation 2) . How can i overcome the difference in collation? When replicating articles there is an option, copy collation (true/false). Can this feature help ?

Differences between signed and unsigned dlls

Hi, Can someone brief on differences between signed and unsigned dlls. How can we test each of these ? thanks in advance sam

what is the differences between PostgreSQL and SQL?

are they the same? i mean, can you create database in PostgreSQL just like how you create it with SQL?  

Error when change single column collation


I try to change a collation on column FirstName on table Person. Then I got following error:

Msg 5074, Level 16, State 1, Line 1
The index 'IX_...' is dependent on column 'FirstName'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN FirstName failed because one or more objects access this column.

So should I drop the index before the change and create it again after the change? Any other possible impact on existing data for such kind of change?

How are people handling XP vs. Windows 7 differences?


How are people handling XP vs. Windows 7 differences in the UI?

For example, an icon is 16 x 16 pixels on every OS... so if you have a list box or list control, you would have a selection rectangle 18 pixels high (perfectly centered around the icon)... now the problem occurs with the text. On XP, you have 8 pixel tall fonts, so the font is perfectly vertically centered. On Windows 7, for some reason, they went to 9 pixel tall fonts... now everything is misaligned and impossible to align.

If you have text next to a 16 x 16 pixel icon, the text either looks too low or too high within the selection rectangle.

Are people forcing the font to 8 pixels high? just in those situations? throughout the entire app? etc. I guess you can make the selection rectangle 17 pixels high to make it look better, but then the selection rectangle next to the icon will look misaligned.


SQL Server 2008 collation design techniques


Can anyone provide some insight into design techniques when multiple languages are required within SQL Server?

Let me tell you about our situation. We currently have a database that holds French content. New languages are going to be added (Chinese, Arabic etc.). We have to make a decision to determine what would be the best approach to deal with all those languages.


Here are the approaches we identified:


o   I database per language:

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend