Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/Midas/TClientDataSet    [ Add a report in this area ]  
Report #:  31812   Status: Reported
on Windows 2003, Delphi 2006 ClientDataSet  can not write unicode to  nText in MSSQL or MEMO in Access
Project:  Delphi Build #:  10.0.2288.42451
Version:    10.0 Submitted By:   Bear Xu
Report Type:  Issue Date Reported:  7/27/2006 7:49:18 AM
Severity:    Infrequently encountered problem Last Updated: 1/18/2007 1:30:14 PM
Platform:    All platforms Internal Tracking #:  
Resolution: Duplicate  Resolved in Build: : None
Duplicate of:  31640
Voting and Rating
Overall Rating: (2 Total Ratings)
5.00 out of 5
Total Votes: 13
Description

See Report 31640:

Delphi 2006 ClientDataSet can not support MSSQL nText Field well with unicode
Steps to Reproduce:
None
Workarounds
1. Set DataSetProvider.ResolveToDataSet=True  (to save data correctly)
2. Use field.AsWideString to read and write the value, do not use .AsString or .Value (to save  data correctly)
Attachment
MemoTest.zip
Comments

None

Server Response from: ETNACODE01