UTF8 and BLOB

[edsperez]

I converted one of our development database character set from US7ASCII to UTF8(Unicode). When the programmer tried retrieving data from a BLOB column using a Java program, he cannot retrieve the data. There was no Oracle error but the application returns message that says it cannot open the files.

Is there a known error on oracle BLOB and LONG column datatype when using UTF8 Character set?

[kgb]

Which version Oracle do you use?

[edsperez]

I'm using Oracle 8.1.7 on HP UX

[kgb]

O'k, if your database worked befor with US7ASCII without problem with BLOB, the reason in WRONG CONTERTION from US7ASCII to UTF8, I had similar problem with convertion - all national symbolses were converted to '¿'. We had 8.1.5. But it seems to me that bug was not fixed.
Go to this thread:

http://www.dbasupport.com/forums/sho...threadid=11009

And play with convertion.
Best wishes.

[kgb]

Little program I used for hacking export file.

#include
#include
main()
{
FILE *in_file;
char s=''; --<--- chr(31)
int x;
if((in_file = fopen("exp.dmp","r+w")) == NULL)
{printf("\n Error of opening file 'exp.dmp'\n\n");
exit(1);}
fseek(in_file,'☺',0); --<--- chr(1)
fgetc(in_file);
if ( fwrite (&s, 1, 1, in_file) != 1 ) printf("Error of writing.\n" );
fclose(in_file);
printf("\n Done !!!\n\n");
}