oracle - Adaptive Server Enterprise ASCII function for multi-byte characters -
while converting oracle sybase ase encounter next issue: ascii function doesn't homecoming code multi-byte characters properly, looks gets first byte. example, next statement returns 34655
select ascii('㍉') dual
while in sybase returns 63
select ascii('㍉')
adaptive server has next language settings language: japanese character set: eucjis
even if utilize sybase uscalar function
select uscalar('㍉')
it returns 63 passing uscalar function hex equivalent of japanese symbol gives different result, not same in oracle
select uscalar(0x875f)
returns 24455
but in way issue appears - i'm not able cast symbol hex
select convert(varbinary,'㍉')
returns first byte 1 time again (0x3f)
please help me find out appropriate way of getting right ascii code of multi-byte japanese symbols in adaptive server enterprise.
oracle ascii special-characters sybase-ase multibyte
No comments:
Post a Comment