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 15 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x1945
x473
x22

asked: Oct 26, 2009 at 02:21 AM

Seen: 1848 times

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