October 13, 2009 at 4:20 am
Hello,
I am using SQL 2005.
I have a function I need to create on a server in Sweden. When I create the function the collation defaults to Icelandic. Is there a way to change that?
The server collation is set to Latin, every collation I can see on system databases, the database itself is all Latin. The only place the collation is set to Icelandic is on that function.
Thank you
This is the function:
ALTER FUNCTION [dbo].[Split]
(
-- Add the parameters for the function here
@List nvarchar(2000),
@SplitOn nvarchar(1)
)
RETURNS @RtnValue TABLE
(
Id int identity(1,1),
Value nvarchar(100)
)
AS
BEGIN
While (Charindex(@SplitOn,@List)>0)
Begin
Insert Into @RtnValue (value)
Select
Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))
Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List))
End
Insert Into @RtnValue (Value)
Select Value = ltrim(rtrim(@List))
Return
END
October 13, 2009 at 4:22 am
just a simple question, what is the collation for the user database that you are creating this function in
this is from BOL (Books Online) from the CREATE FUNCTION section
COLLATE collation_name
Specifies the collation for the column. If not specified, the column is assigned the default collation of the database. Collation name can be either a Windows collation name or a SQL collation name. For a list of and more information about collations, see Windows Collation Name (Transact-SQL) and SQL Server Collation Name (Transact-SQL).
The COLLATE clause can be used to change the collations only of columns of the char, varchar, nchar, and nvarchar data types.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy