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

avatar image

113 6 6 9

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

1 answer: sort voted first

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

avatar image

Rob Farley
5.8k 16 22 28

(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



Answers and Comments

SQL Server Central

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



asked: Oct 26, 2009 at 02:21 AM

Seen: 2239 times

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

Copyright 2018 Redgate Software. Privacy Policy