UTF8 / TIBCStoredProc-Problems
Posted: Mon 12 Oct 2015 09:33
Hi,
I'am still playing with Delphi 10 Seattle and IBDAC 5.4.11 and UTF8.
This is my Database:
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:
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
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 ;^
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 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