jason chapman
Re: IBX and Memo Field Question Delphi 2010

Re: IBX and Memo Field Question Delphi 2010

jason chapman wrote:
>> {quote:title=John McLaine wrote:}{quote}
>> Hello,
>> Maybe I make a silly question but here it is...:)
> I am in the same boat.  I am looking at a D5 app for a client migrating to D2010.  There seem to be 2 problems.  One is opening a TIBDataset returning no rows with a blob field and the one you describe below is the other.

Fixed in XE.

>> I am currently evaluating Delphi 2010 Trial, testing some common code I use on my applications. During the testing of some database code.. I noticed that with the version of IBX shipped with Delphi 2010 the BLOB_SUBTYPE 1 fields (Text Memo) are all mapped to a TWideMemoField.
>> My problem arises when I use a Database with no charset defined, all the memo fields are read as they where widestrings memos although they are ansi, so strange results appear on the DBMemos used to display de data, the rest of the data (varchars in DBEdits for example) are displayed correctly as usual.
>> Is that an issue or as designed ?
> AFAICS it doesn't know how to interpret the data, so you need to give the DB a connection a character set.
> For your answer see:
> Or double click the Database Component and select a Character Set, e.g. UTF8.  Now Unicode is still a bit of a mystery to me, so which Character Set to use when your DB isn't set to have one, I don't know.

Choose anything (UTF-8 is just fine)  All string data comes in that way when 
setting the lc_ctype.  There was a change in TWdieMemoField I didn't catch in 
D2010 so code that worked to continue just leaving it straight ANSI in D2009 was
broken D2010.  This is working again just fine in XE and you can leave the 
lc-ctype empty for ANSI databases in XE.

>> Thank you for some answer.
>> Regards,
>> John.

Jeff Overcash (TeamB)
       (Please do not email me directly unless  asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted  corridors of Whitehall.
FYI: Phrase searches are enclosed in either single or double quotes
Originally created by
Tamarack Associates
Thu, 21 Oct 2021 15:05:44 UTC
Copyright © 2009-2021
HREF Tools Corp.