sql server - Why does char allow registered sign? -

the data type of column char , find allows ® (registered sign).

doesn't char support ascii symbols? isn't ® unicode symbol? other symbols supported char?

doesn't char support ascii symbols?

since char data type has 8 bits, , ascii uses 7 of them, sql server uses extended ascii set selected code page when storing non-unicode character data.

what other symbols supported char?

run sp_helpsort see code page server using. when code page 1252 selected, code set allows character ® encoded 0xae, or 174₁₀. number fits in byte, can safely use in column of char data type.