如何取的字符串中的某个字节，有什么函数

[zlh0614]

我需要取得字符串中的字节，
例如print ascii(substring('健',1,1))，一个汉字应该有两个字节，也就应该能打出两个ascii码，但现在只能打出一个，请问如何能打出两个，谢谢~！

[sysmaster]

这里用的是unicode都是两个字节的,

不过我在VB中打汉字的ASC码是负数,但取一半没研究过!

[pengdali]

print UNICODE(substring('健',1,1))

[愉快的登山者]

print ascii(substring('健',1,1))
select cast(cast('健' as binary(2)) as int) / 256, cast(cast('健' as binary(2)) as int) % 256


愉快的登山者

⊙
◢◣◢◣◢◣

[愉快的登山者]

print ascii(substring('健',1,1))
select cast(cast('健' as binary(2)) as int) / 256, cast(cast('健' as binary(2)) as int) % 256


愉快的登山者

⊙
◢◣◢◣◢◣

[愉快的登山者]

print ascii(substring('健',1,1))
select cast(cast('健' as binary(2)) as int) / 256, cast(cast('健' as binary(2)) as int) % 256


愉快的登山者

⊙
◢◣◢◣◢◣