contains character data that cannot be converted

[tao zhang]

My server db is oracle10g,charset ZHT16BIG5
My client db is asa10,charset Big5-HKSCS
My mobilink server is asa10
When i download from server,It always give me a error like this"A
downloaded value for table t_order_hdr (column #59) contains character
data that cannot be converted"

I know column #59 has some special characters,but i don't want to
modify the characters,so how can i handle
this error in mobilink(by download script ,download store procedure
act)?????

[rtoellner]

You may want to look at explicitly converting that column in your
download script. Look at CONVERT and CAST. For example: CAST( column
as binary )

I'm in a similar situation - though my script downloads the data fine,
my application reading the SQLAny DB does not get all the chars when I
read it in as a string. So, I'm trying other ways using the above.