Hi

Further to your question.
When I connect using a TIB_Connection or a TIBODatabase the CharSet
property changes from '' to 'UTF8'. So it looks like the database is
correctly picking up the Character set.

I am using FB 2.0 as this is what our clients are using. I have just
restored the data on to a FB 2.5 server and everything works perfectly !!!!!

Interestingly the issue with FB 2.0 and IBO appears to be reading the
data, as the restored database shows with the data was inserted
correctly when I was doing my initial testing.

Any suggestions. Our plan was to move our code base to Delphi XE2 /
Unicode and release. In a later release we would move all users from FB
2.0 to FB 3 (when its released). We really don't want to force users to
change database at the same time as doing a major code and component
upgrade.

Thanks
Rob

On 18/07/2013 10:49 a.m., Robert Martin wrote:
> 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
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>