kd11
Hall of Fame
Points: 3447
More actions
November 16, 2015 at 12:57 pm
#313134
How would one search for " ă " in the database or convert the lower case omega symbol " ῳ ". Doesn't each character has an unique hex value.
Sergiy
SSC Guru
Points: 110192
November 16, 2015 at 2:46 pm
#1840164
Those are double-byte characters. They have corresponding HEX values, but not single byte ones.
SELECT CONVERT(VARBINARY, N'?')
You can search for them, but you must specify them as UNICODE:
WHERE [Column] like N'%?%'
_____________ Code for TallyGenerator
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply