Hi
Its CHARACTER SET UTF8 COLLATE UTF8

On 18/07/2013 10:42 a.m., IBO Support List wrote:
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3349 / Virus Database: 3204/6499 - Release Date: 07/17/13
>
>