Sybase 11.9.2
~~~~~~~~~~~~~
select id, name, description from master..syscharsets 
-- id	name	    description
-- 0	ascii_8	    ASCII-8 - 7-bit ASCII, with implementation-defined characters for values 128-255.
-- 1	iso_1   	ISO 8859-1 (Latin-1) - Western European 8-bit character set.
-- 2	cp850   	Code Page 850 (Multilingual) character set.
-- 3	cp437   	Code Page 437, (United States) character set.
-- 4	roman8  	Hewlett-Packard proprietary character set for European locales.
-- 5	mac	        Macintosh default character set for Western European locales.
-- 50	bin_iso_1	Binary sort order for the ISO 8859/1 character set (iso_1).


select sortkey( 'Roger', 'binary'   ) -- 0052006F006700650072
select sortkey( 'Roger', 'default'  ) -- 08540820076E073A08540008
select sortkey( 'Roger', 'altnoacc' ) -- 08540820076E073A0854
select sortkey( 'Roger', 'altdict'  ) -- 08540820076E073A08540008
select sortkey( 'Roger', 'altnocsp' ) -- 08540820076E073A0854
select sortkey( 'Roger', 'scandict' ) -- 08540820076E073A085400020008000800080008
select sortkey( 'Roger', 'scannocp' ) -- 08540820076E073A0854
-- select sortkey( 'Roger', 'gbpinyin' )
select sortkey( 'Roger', 'dict'     ) -- 08540820076E073A085400020008000800080008
select sortkey( 'Roger', 'nocase'   ) -- 08540820076E073A0854
select sortkey( 'Roger', 'nocasep'  ) -- 08540820076E073A0854
select sortkey( 'Roger', 'noaccent' ) -- 08540820076E073A0854
select sortkey( 'Roger', 'espdict'  ) -- 08540820076E073A085400020008000800080008
select sortkey( 'Roger', 'espnocs'  ) -- 08540820076E073A0854
select sortkey( 'Roger', 'espnoac'  ) -- 08540820076E073A0854
-- select sortkey( 'Roger', 'cyrdict'  )
-- select sortkey( 'Roger', 'rusdict'  )
-- select sortkey( 'Roger', 'turdict'  )
-- select sortkey( 'Roger', 'sjisbin'  )
select sortkey( 'Roger', 'thaidict' ) -- 08540820076E073A08540008

-- These two are not the same 
select name from syscolumns order by lower( name )
select name from syscolumns order by sortkey( name, 'altnocsp' )

See also sp_helpsort