question

SQLserver_novice avatar image
SQLserver_novice asked

Czech character identification

We are currently on SQL Server 2000 and need to identify records with Czech Characters from the database tables. Can anyone guide me how this can be done in SQL Server 2005/SQL Server 2000 ?

sql-server-2005sql-server-2000collation
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Rob Farley avatar image
Rob Farley answered

So, the Czech characters are áčďéěíňóřšťúůýž, right?

So if you're looking for these characters, you should make sure you're using a collation that is accent sensitive. Then you can do something like:

WHERE col LIKE '%á%' COLLATE Latin1_General_CI_AS

...to see if you have this character used anywhere.

To get a list of columns, use sys.columns. Join to sys.objects and sys.schemas to find out what tables they're in. You're only interested in the columns which are one of the string types, so join to sys.types to get the ones you want.

Oh, and if you're in SQL 2000, then use sysobjects, etc. The principle still holds though.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.