replace unicode substring

I am trying to use REPLACE function in a SQL Server 2000 Script to replace some corrupted unicode data with the correct characters. I made it but the problem is case sensitiveness problem. For example "print replace(N'ÐðððÐÐ', N'ð', 'ğ')" command results like that: "ğğğğğğ", but it suppose to be like that: "ÐğğğÐÐ". Corrupted datas are 'Ð' is 0xD000 and 'ð' is 0xF000. The correct datas are 'Ğ' is 0x1E01 and 'ğ' is 0x1F01. If you know a way to use REPLACE function case sensitive or any other solution to change data, it will be helpfull. Thanks a lot.

kelesAsked:
Who is Participating?
 
rafranciscoCommented:
Try this:

print replace(N'ÐðððÐÐ' COLLATE Latin1_General_CS_AS , N'ð', N'ğ')
0
 
rafranciscoCommented:
Try this:

print replace(N'ÐðððÐÐ' COLLATE Latin1_General_CS_AS , 'ð', ğ)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.