Post reply

Special Characters

  • 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.

  • 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