The server is likely transliterating stuff.
What is the character set of your column?

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Wednesday, July 17, 2013 3:44 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Unicode / Encryption issue

Hi

We have a string encryption string function that can encode a unicode text
string and later decode it to the original (unicode) text. This was tested
with text in TEdit controls as follows ...

(Note these values are made up and this is shown to show how the system was
tested)

Edit1.Text = 'fred'
-> Edit1 Encrypted to Edit2
Edit2.Text = '12345' (This normally shows as funny characters)

-Edit2 decrypted to Edit3
Edit3.Text = 'fred'

However In actual use it fails to decrypt. I have tracked this to what is
actually stored in the database. In my test app the value in shown in Edit2
is not what is stored in the database !

I am using IBObjects ver 5.2.0 6 and my DB field is defined as UTF8. I am
using .AsString to read and write from the database.

Any idea what is going on?

Thanks
Rob



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links