Tag Info

New answers tagged

7

The trick here is to realize that these characters that you see in the question with the "accents" aren't really the characters (i.e. "These aren't the droidscharacters you are looking for" ;-) ). The "accents" are various types of notations indicating things like: vowels (lines and dots that are typically under the letters) pronunciation (dots that are ...


1

I've used a Numbers table. There are any number of posts explaining what this is, why its useful and how to get one efficiently. I don't use any built-in functionality to convert accented characters to the non-accented equivalent. Instead I build a lookup list which you will populate with the conversions you require. You will have to use nvarchar and ...


0

This is an interesting problem, and one I sort of faced a while back working with Japanese characters. I hit a bit of a brick wall trying to locate your problem characters, though I hope this gets you going somewhere with finding them. First I got all NCHARs into a table: SET NOCOUNT ON DECLARE @cnt INT = 1 DECLARE @sqlcmd NVARCHAR(512) = '' CREATE ...



Top 50 recent answers are included