1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| DECLARE @position int, @n nvarchar(1000)
SET @position = 1
SET @n = 0x45006D0070006C006F0079006500650028007300290020003A00200000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F000000070000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F000000070000003F0000003F0000003F00
WHILE @position <= DATALENGTH(@n)
BEGIN
SELECT @position as Position,
CONVERT(nchar(1), SUBSTRING(@n, @position, 1)) as UnicodeCharacter,
UNICODE(SUBSTRING(@n, @position, 1)) as UnicodeValue
SET @position = @position + 1
END
GO
-- nettoyage
DECLARE @n nvarchar(1000)
SET @n = 0x45006D0070006C006F0079006500650028007300290020003A00200000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F000000070000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F0000003F000000070000003F0000003F0000003F00
SELECT @n, DATALENGTH(@n), LEN(@n)
SET @n = LEFT(@n, CHARINDEX(NCHAR(63),@n))
SELECT @n, DATALENGTH(@n), LEN(@n) |
Partager