Monday 15 August 2011

oracle - Adaptive Server Enterprise ASCII function for multi-byte characters -



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