title: Trouble with type mismatch with TBCDField and TfmtBCDfield and oracle compatibility
body: <p>I am converting a large application from Delphi 6 to Delphi 2009.</p>
  
  <p>It was built originally to use Oracle 8i but now needs to use to Oracle 11g. The original application is quite happily using oracle 11g and will do so if I rebuild it using Delphi 6.</p>
  
  <p>To get over some character set / character display problems and other minor annoyances with the application that have developed over the last 11 years, I decided to rebuild it in a later version of Delphi (Which has also been delayed for a couple of years hence using 2009.) which was bought for the purpose. I have now defeated the 550+ Compiler Warnings about this and that and the other.</p>
  
  <p>But now almost every table/dataset I try to open against my test oracle 11g database reports "Type Mismatch for field 'xxxxxx' Expecting BCD actual FmtBCDField.</p>
  
  <p>Is there a way around this without opening all 80+ datamodules that will <b>guarantee</b> compatibility with the clients database installation? I don't mind changing them all but I can't test it against the live database without a lot of messing about and don't want to do it only to get the opposite error at the client's site!</p>
  
  <p>These are nearly all persistent fields in TClientDataSets connected to ADO queries but are accessed by using FieldByName in (again nearly) all cases.</p>
  
  <p>Any Ideas?</p>