Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

Outputting duplicate strings

I have a problem when returning address information from a table that contains foreign/extended characters. The results combine different words as one result, e.g. 'Angouleme' and 'Angoulême' are returned as a single result. Is there a way to ensure that these two values are returned separately?

thanks

[315 byte] By [alpha0mega] at [2008-1-7]
«« VS 2k5 CR10.2 Deploy=Error in Unknown.Rpt
»» IAuthorizationPolicy ?
# 1

Make sure that the collation on the database that this table is in is setup to be sensitive to those charachter differences.

ShawnNWF at 2007-10-2 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2
Hi,

cheers for the reply, this is going ot sound a bit silly but i dont really know how to chang ethe collation and a search online seems to indicate it is slightly more then just a tick box..

what are the various collation options, and how do i find out my current one?

how easy / difficult would it be to change the collation of the entire database if need be, as i did not set it up...

regards

Chris

alpha0mega at 2007-10-2 > top of Msdn Tech,SQL Server,Transact-SQL...
# 3

Here is the technet article describing the different levels of collation that are available.

http://technet.microsoft.com/en-us/library/ms144250.aspx

If you are not comfortable changing the collation on the database, I would talk to whoever designed the database and see what they think. There can, and probably would be, other things that would be affected by a collation change.

ShawnNWF at 2007-10-2 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified