Discussion:
How to get WideString type data value from Field
(too old to reply)
Emmanuel
2006-07-07 17:40:49 UTC
Permalink
How to get WideString type data value from Field?
because Field->AsString will make the data currpt for different OS
How can I get the orginal Data by WideString?
JD
2006-07-08 18:30:43 UTC
Permalink
Post by Emmanuel
How to get WideString type data value from Field?
because Field->AsString will make the data currpt for different OS
How can I get the orginal Data by WideString?
From the help : DevGuide Developing database applications
Converting field values:

A TWideStringField will correctly convert using AsVariant,
AsString, AsInteger, AsFloat, AsCurrency, AsBCD, AsDateTime,
AsSQLTimeStamp, and AsBoolean.

Sounds like you haven't correctly defined the field.

~ JD
Emmanuel
2006-07-09 15:11:40 UTC
Permalink
But I am auto create the field by New Field, And in the Interbase using
Varchar Unicode, How can I create TWideStringField ?
Post by JD
Post by Emmanuel
How to get WideString type data value from Field?
because Field->AsString will make the data currpt for different OS
How can I get the orginal Data by WideString?
From the help : DevGuide Developing database applications
A TWideStringField will correctly convert using AsVariant,
AsString, AsInteger, AsFloat, AsCurrency, AsBCD, AsDateTime,
AsSQLTimeStamp, and AsBoolean.
Sounds like you haven't correctly defined the field.
~ JD
Emmanuel
2006-07-10 09:43:37 UTC
Permalink
I define the field is VARCHAR (30) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS

If I use TWideStringField , there is error : Type mismatch for field
Post by JD
From the help : DevGuide Developing database applications
A TWideStringField will correctly convert using AsVariant,
AsString, AsInteger, AsFloat, AsCurrency, AsBCD, AsDateTime,
AsSQLTimeStamp, and AsBoolean.
Sounds like you haven't correctly defined the field.
Emmanuel
2006-07-10 09:46:01 UTC
Permalink
I define the field is VARCHAR (30) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS

If I use TWideStringField , there is error : Type mismatch for field "XXX",
excpecting: WideString actual:String
Post by Emmanuel
I define the field is VARCHAR (30) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS
If I use TWideStringField , there is error : Type mismatch for field
Post by JD
From the help : DevGuide Developing database applications
A TWideStringField will correctly convert using AsVariant,
AsString, AsInteger, AsFloat, AsCurrency, AsBCD, AsDateTime,
AsSQLTimeStamp, and AsBoolean.
Sounds like you haven't correctly defined the field.
Emmanuel
2006-07-10 16:47:02 UTC
Permalink
HELP ME
JD
2006-07-11 14:36:34 UTC
Permalink
I searched the archives:

http://www.tamaracka.com/search.htm

and found a post by Jeff Overcash where says that IB doesn't
support widestrings (including WideStringField) but that was
from 2000. I appologize if I mislead you (works great with
ADO).

Other threads showed that individuals were indeed using
UNICODE_FSS successfully as a secondary character set
for individual fields (like you are doing).

If, for what ever reason, you can always resort to a blob but
that would most likely preclude you from using data-aware
components with that field.

~ JD
Emmanuel
2006-09-02 15:20:56 UTC
Permalink
UNICODE_FSS cannot solve my problem
1.Unicode should let us can see the same data in different OS,but I found
that if I save simlpe Chinese Word or tradition chinese word to Interbase
using simple Chinese OS, then when the data read under tradition chinese OS,
all the chinese word changed to be irrecognizable.
2. for All Unciode Chinese word Stored in Interbase with UNICODE_FSS ,there
is no method get data as unicode, for example, after asString, all unicode
will change to ASCII Code
Post by JD
Other threads showed that individuals were indeed using
UNICODE_FSS successfully as a secondary character set
for individual fields (like you are doing).
Loading...