Subject | Again: Unicode |
---|---|
Author | mircostange |
Post date | 2004-10-22T14:26:54Z |
I am still in the situation of finding out, whether it is possible
to migrate my existing Delphi/IBO application to unicode support.
Some information has been here in the group, but I simply don't get
anything to work.
I created a sample database with default charset none and created
the following table:
CREATE TABLE PERSON
(
PERSONID INTEGER NOT NULL,
FIRSTNAME CHAR( 40) CHARACTER SET UNICODE_FSS
NOT NULL COLLATE UNICODE_FSS,
LASTNAME CHAR( 40) CHARACTER SET UNICODE_FSS
NOT NULL COLLATE UNICODE_FSS,
GENDER CHAR( 10) NOT NULL COLLATE NONE,
AGE SMALLINT,
CONSTRAINT PK_PERSON PRIMARY KEY (PERSONID)
);
firstName and lastName should support unicode, while gender doesn't
need this.
I then tried to write a small Delphi app to connect to the db as
follows:
-created an IB_Connection
-created an IB_Query with "select * from person" and auto-generated
update sql
-created an IB_Datasource, bound to IB_Query
-dropped an IB_Grid to show the data
Result: everything is fine, but entering unicode (japanese,
cyrillic, ...) results in "???"
It seems, the IBO controls don't support Unicode, because the
default Delphi controls don't.
I then tried the following:
- use IBOQuery with same select
- use standard Delphi TDataset
- bind standard Delphi grid (don't expect this to show Unicode just
for navigation)
- download, install and bind TNT Edit box with unicode support
- set font to Tahoma (otherwise it won't show properly)
Result: everything is find, I can enter unicode chars into the edit
box, moving to the next record and back shows "???" .... arghh..
Has anyone got anything to run with Unicode+Firebird+IBObjects?
What am I doing wrong here? What could I do or contribute to make it
work? Who can help? Please....
Thanks for any feedback
to migrate my existing Delphi/IBO application to unicode support.
Some information has been here in the group, but I simply don't get
anything to work.
I created a sample database with default charset none and created
the following table:
CREATE TABLE PERSON
(
PERSONID INTEGER NOT NULL,
FIRSTNAME CHAR( 40) CHARACTER SET UNICODE_FSS
NOT NULL COLLATE UNICODE_FSS,
LASTNAME CHAR( 40) CHARACTER SET UNICODE_FSS
NOT NULL COLLATE UNICODE_FSS,
GENDER CHAR( 10) NOT NULL COLLATE NONE,
AGE SMALLINT,
CONSTRAINT PK_PERSON PRIMARY KEY (PERSONID)
);
firstName and lastName should support unicode, while gender doesn't
need this.
I then tried to write a small Delphi app to connect to the db as
follows:
-created an IB_Connection
-created an IB_Query with "select * from person" and auto-generated
update sql
-created an IB_Datasource, bound to IB_Query
-dropped an IB_Grid to show the data
Result: everything is fine, but entering unicode (japanese,
cyrillic, ...) results in "???"
It seems, the IBO controls don't support Unicode, because the
default Delphi controls don't.
I then tried the following:
- use IBOQuery with same select
- use standard Delphi TDataset
- bind standard Delphi grid (don't expect this to show Unicode just
for navigation)
- download, install and bind TNT Edit box with unicode support
- set font to Tahoma (otherwise it won't show properly)
Result: everything is find, I can enter unicode chars into the edit
box, moving to the next record and back shows "???" .... arghh..
Has anyone got anything to run with Unicode+Firebird+IBObjects?
What am I doing wrong here? What could I do or contribute to make it
work? Who can help? Please....
Thanks for any feedback