UTF8 / TIBCStoredProc-Problems

[Jank]

Hi,

I'am still playing with Delphi 10 Seattle and IBDAC 5.4.11 and UTF8.

This is my Database:

Code: Select all

set term ^ ; 

set SQL DIALECT 3^
set names UTF8^

create database 'localhost/3050:d:\db\test.fdb'
user 'SYSDBA' password 'masterkey'
page_size 16384
default character set UTF8 collation UTF8^

create procedure SP_GETCHAR5
returns (
    DATA char(5))
as
begin
  data = '12345';
end^

set term ;^

My Delphi-Project simply consists of a TIBCConnection with these options:
Charset = 'UTF8'
UseUnicode = True
EnableMemos = True

and a TIBCStoredProc that is calling SP_GetChar5.

Here is my Source:

Code: Select all

  IBCConnection1.Open;
  IBCStoredProc1.ExecProc;
  self.caption := IBCStoredProc1.Params[0].asstring;
  IBCConnection1.Close;

If I execute that, the result is: '��G'#2#1

If I compile the same project with xe7 and Ibdac 5.4.11 for the same database I have no Problem.

What am I doing wrong?

Regards, Jan

[ViktorV]

We have already fixed this issue. The fix will be included in the next IBDAC build.

[Jank]

That's great! When can I expect the next build or is there a nightly build available?

[ViktorV]

We can send you a night build including the fix. For this, please send your license number for IBDAC and the IDE version to viktorv*devart*com.