views:

58

answers:

0

Hello

I'm using a dbGo TADODataset in Delphi XE to read data from a SQL Server 2008 table. All the string fields are nvarchar or nchar.

The nvarchar fields map to TWideStringField with no problems.

The problem is with an nchar(1) field, this maps to a TStringField fine but not to a TWideStringField - when I configure the field to be TWideStringField I get the error:

Type mismatch for field 'foobar', expecting: WideString actual: FixedChar

The problem in using a TStringField is that it is UTF8 and we want to make our application fully unicode compliant.

Any suggestions on this?