Hungarian, Czech and Polish have accent marks dropped when stored in SQL Server 2000

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

What type of accent marks are you looking for. SQL_Latin1_General_CP1_CI_AS supports quite a lot of accented characters like ç,ê,è,ë,ï etc.

You can create a simple list of all the characters contained in your collation by running this script:

DECLARE @num int

SET @num = 65

WHILE @num < 256

BEGIN

SELECT @num,char(@num)

SET @num = @num +1

END

Hope this helps

Markus

[font="Verdana"]Markus Bohse[/font]

M Shah SSCommitted Points: 1683 More actions · Answer 2

Thanks. I used unicode ntext data to store the data and that seemed to have resolved the issue.

Manisha