Page 1 of 1

Unicode with BFILE

Posted: Wed 13 May 2009 21:15
by jdorlon
Hello,

I have an 11g database with AL32UTF8 characterset. I am using ODAC 6.7 with Delphi 2009. I have OraCall.OCIUnicode = True and TOraSession.Options.UseUnicode = true.

I created this folder on my windows server: C:\실험
I put a file in it called drop.bmp.
I created this directory on my database: CREATE OR REPLACE DIRECTORY TEST_DIR AS 'C:\실험';

I have this table:

create table bfile_test
(col1 number,
bfile_col bfile,
comment_col varchar2(30);

INSERT INTO bfile_test
VALUES (1, bfilename('TEST_DIR' , 'drop.bmp'), 'test');

commit;

Now, when I see that field in a TSmartQuery and check TBFileField.Exists, it comes back as false. It should be true. If I repeat the test with an ascii-named folder on my server, it works.

Is this an ODAC bug?

Thank you

-John

Posted: Thu 14 May 2009 06:48
by Plash
This is an Oracle bug. It is not related to ODAC.

Posted: Thu 14 May 2009 18:51
by jdorlon
ok, thank you.