Subject Unicode help
Author Robert Martin
Hi

I have an older version of IBO 5 (5.0.2 52) installed in Delphi Xe2
which were are not really using. However we will shortly need to build a
very basic app allowing entry and display of Unicode text. Primarily I
want to add Chinese (simplified and traditional) as well as Thai.

I am attempting to enter some test text. This displays ok in my entry
field but once inserted into the database the chinese charaters showed
either as ???? (where the DB character set was none) or as funny ascii
characters (採用新) where the db field was defined at UTF8.

In my test app I am using an IBOQuery to insert with the following...

sql:

INSERT INTO aaa (id, Text)
VALUES (:id, :text)

Code:
with InsertIBOQuery do begin
ParamByName('ID').AsInteger := NextId;
ParamByName('Text').AsWideString := TextEdit.Text;
ExecSQL;
end;


I am viewing the results in a TDBGrid from the following SQL

SELECT *
FROM aaa
ORDER BY id DESC


Am I doing something wrong here ?



My aim is to have a Delphi XE2 app developed to allow entry of non
english language details. However a D2007 developed, IBO4 based app
sends this data (via XML) to another system (web site). If I get my EX2
app working, will I be able to use IBO4 to access it correctly and
export it?

Thanks
Rob