Click here to Skip to main content
14,865,088 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

I am working in one windows application and for that i use sqlserver 2008 for database connectivity.

Now i want to change default collation as Indic_General_90_CI_AS for my database but sql server not allow to do that.it show me the error like

Collation 'Indic_General_90_CI_AS' is supported on Unicode data types only and cannot be set at the database or server level.

And Here is my store Procedure for that

SQL
USE [gujarati_demo]
GO

ALTER DATABASE gujarati_demo COLLATE Indic_General_90_CI_AS 
GO
/*select COLLATIONPROPERTY ('Indic_General_90_CI_AS','@gujarati_demo')*/

/****** Object:  StoredProcedure [dbo].[SP_guj]    Script Date: 05/31/2013 17:10:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_guj]
(	
	@Parameter int = 0,
	
	@Name Nvarchar(max)= Null

	
)
			
AS

set QUOTED_IDENTIFIER ON

begin transaction

	DECLARE @SQL_Query VARCHAR(max)
	
	if @Parameter = 1 /* Inserting Party */

	begin
		insert into gujarati_demo values (@Name)
	end
	if @Parameter = 2 /* Inserting Party */

	begin
	
		select Name FROM gujarati_demo WHERE Name=@Name 
	end
	
Commit Transaction


If any one have the solution of this error please help me.


Advance Thanks and Regards
Posted
Updated 31-May-13 23:33pm
v3

1 solution

   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900