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