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 17410. number fits in byte, can safely use in column of char
data type.
Comments
Post a Comment