Hi Andeas

You are likely correct. I have actually replaced my Unicode string
encryption with a system that that uses AES encryption streamed to a
Blob field. That's working fine now. However during my testing I
discovered that some Chinese text I grabbed from a web site is also not
correctly being stored in the DB, so there is still some sort of problem
going on here.

Thanks
Rob

On 18/07/2013 7:47 p.m., Andeas Hesse wrote:
> What is the Result of the encryption, that you store in the DB?
>
> Is it:
> - Utf8
> - Ascii
> - Binary
>
> I wouldn't expect, that a encrypted utf8 string results in a valid
> utf8 string.
>
> --
> Andreas
>
> Am 17.07.2013 23:44, schrieb Robert Martin:
>> 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
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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/6500 - Release Date: 07/17/13
>
>