Inserting japanese/chinese data in blob data type

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

BLOB data type is to be used for binary data only. For storing character data , use CLOB data type. LLOYD SERRAO <lloyd_s@rediffmail.com> wrote: Dear All, When i try inserting japanese or chinese data in to blob data type it stores as junk, something like this 次ã#65533;« å¹´, but when insert the same data in a char or varchar field it stores as #27425;#12395; #24180;. Is it that blob does not support japanese data. Thanks in advance. Best Regards, Lloyd --------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger