x

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 ?

more ▼

asked Oct 26, 2009 at 02:21 AM in Default

SQLserver_novice gravatar image

SQLserver_novice
113 6 6 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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.

more ▼

answered Oct 26, 2009 at 02:33 AM

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x476
x22

asked: Oct 26, 2009 at 02:21 AM

Seen: 1954 times

Last Updated: Oct 26, 2009 at 06:44 AM