Sql – String compare with ‘strange chars’ in SqlServer

sql-serversql-server-2008string

I have some content in our database with (for our language) 'strange' characters.

For example:

Å

When using the like statement in Sql Server with the letter A, this does not return a result because the Å is not an A.

Is there a way in SqlServer to treat the Å as an E (and the é as an 'e' etc)?

Best Solution

Do you mean "Å as A" or "Å as E"?

For the first, you can coerce the collation to accent insensitive

SELECT 1 WHERE 'Å' = 'A'    --No
SELECT 1 WHERE 'Å' COLLATE LATIN1_General_CI_AI = 'A'   --Yes

SELECT 1 WHERE 'é' = 'e'    --No
SELECT 1 WHERE 'é' COLLATE LATIN1_General_CI_AI = 'e'   --Yes

Related Solutions

C# – the difference between String and string in C#

string is an alias in C# for System.String.
So technically, there is no difference. It's like int vs. System.Int32.

As far as guidelines, it's generally recommended to use string any time you're referring to an object.

e.g.

string place = "world";

Likewise, I think it's generally recommended to use String if you need to refer specifically to the class.

e.g.

string greet = String.Format("Hello {0}!", place);

This is the style that Microsoft tends to use in their examples.

It appears that the guidance in this area may have changed, as StyleCop now enforces the use of the C# specific aliases.

Sql-server – Check if table exists in SQL Server

For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version.

To check if a table exists use:

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

Best Solution

Related Solutions

C# – the difference between String and string in C#

This is the style that Microsoft tends to use in their examples.

Sql-server – Check if table exists in SQL Server

Related Question