[DUG] D2007-D2010 upgrade issue

[Willie Juson]

Mmmm.... I'm not sure, the database (Interbase) appears to be using the default "NONE" character set, which I think is not a UNICODE set. There are no column charsets so it's all the default.




-----Original Message-----
From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On Behalf Of Alister Christie
Sent: Tuesday, 16 February 2010 12:06 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] D2007-D2010 upgrade issue

This looks like a unicode issue - is the Grower field a unicode field in 
your database.

I had a similar issue with porting a database from the BDE to firebird 
under D2009 - I just made the firebird database use the ascii characters 
rather than utf-8 or what ever it was using by default.

Alister Christie
Computers for People
Ph: 04 471 1849 Fax: 04 471 1266
http://www.salespartner.co.nz
PO Box 13085
Johnsonville
Wellington 



Willie Juson wrote:
>
> Hi,
>
>  
>
> I’ve been trolling the net trying to find info about this and I’m 
> struggling to find anything useful....  We have a D2007 app that we 
> are porting to 2010. After some initial issues (mostly project paths 
> and component set compatibility stuff) we get everything to compile ok 
> but when we run the app we are getting exceptions  when opening 
> datasets for example ....
>
>  
>
> EDatabase error  myclientdataset: Type Mismatch for field ‘Grower’ 
> expecting string: actual WideString:
>
>  
>
> where “Grower” is a persistent field on the Clientdataset 
> (TStringField) and accompanying TIBQuery(TIBStringField)
>
>  
>
> It seems you fix this by changing the ClientDataset “Grower” Field 
> type to be a TWideStringField.
>
>  
>
> Is this the only way to fix this – change all declarations of 
> TStringField to TWideStringField in persistent TClientDataset fields? 
> I was hoping there might be some other way, like a compiler directive 
> or a setting for the IBDatabase component that we use for the DB 
> connection....
>
>  
>
> Any ideas would be appreciated
>
>  
>
> Thanks
>
>  
>
> Willie
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe