Dear All,

When i try inserting japanese or chinese data in to blob data type it stores as junk, something like this 次ã�« å¹´, but when insert the same data in a char or varchar field it stores as 次に 年. Is it that blob does not support japanese data. Thanks in advance.

Best Regards,

Lloyd

Can you use a CLOB or TEXT data type? These are "char" types, not binary like blob. Maybe this is what's happening to you.

Hope this helps

Iñaki

Hi,

I tried with CLOB too but it still did not work. But i can store french, german & spanish data in blob but the problem arises only for japanese data.
Any workarounds. I will try with text type too. Thanks in advance.

Best Regards,

Lloyd