My table have a NVARCHAR fields I used code, below
with ClientDataSet1 do begin Append; FieldByName('FieldTest').AsString := 'AAA'; Pose; ApplyUpdate(0); end;
But! I used SQL: select FieldTest from TEST I get 'A', only 1 char…
Why??? Delphi 2009/XE Windows 2000/XP SQL Server 2000
Ohh… Because my field type is "VARCHAR". Modify "VARCHAR" to "NVARCHAR" is OK.
Log in to post a comment.
My table have a NVARCHAR fields
I used code, below
But!
I used SQL: select FieldTest from TEST
I get 'A', only 1 char…
Why???
Delphi 2009/XE
Windows 2000/XP
SQL Server 2000
Ohh…
Because my field type is "VARCHAR".
Modify "VARCHAR" to "NVARCHAR" is OK.