replace unicode substring
Posted on 2005-04-16
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.