Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Data aware components with non-Unicode data sources


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Sep 17, 2015 11:00 AM Last Post By: Lajos Juhasz
Trevor Cooper

Posts: 45
Registered: 10/7/10
Data aware components with non-Unicode data sources  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 14, 2015 4:19 AM
Hi,

We have legacy software that connects to databases in pre-2010 Access format, so, presumably, all text and memo fields are stored by default as ANSI in the database. In converting from Delphi 2007 to XE7, we find that TDBMemo and TDBRichEdit cannot cope with ANSI text in the connected memo fields. But it seems that an InfoPower TwwDBRichEdit can as though it detects the character encoding in the connected field.

Setting the font Charset to ANSI_CHARSET appears to make no difference. Is it fair to say that Delphi's transition to Unicode has left its standard data-aware components unable to handle ANSI data sources? Or are there settings we can tweak?

Thanks for any advice.

Trevor Cooper
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: Data aware components with non-Unicode data sources  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 17, 2015 11:00 AM   in response to: Trevor Cooper in response to: Trevor Cooper
Trevor Cooper wrote:

tting the font Charset to ANSI_CHARSET appears to make no
difference. Is it fair to say that Delphi's transition to Unicode has
left its standard data-aware components unable to handle ANSI data
sources? Or are there settings we can tweak?

This is true not just for DB aware component but all the GUI
components. After D2009 they all handle only Unicode strings. Your best
bet is to use non DB-aware components and do the conversion from ANSI
to Unicode and back.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02