Hi
I am facing very strange problem.
I made my database fully unicode compatible...i.e. Varchar to Nvarchar & Text to nvarchar(max).
and at GUI side (Delphi 2009) i replaced all TstringField to TWideString Field and all TmemoField to TWideMemoField
After this, all seems ok and working fine but i noticed one record for perticular field which earlier was text and changed as nvarchar(max) giving me chinese characters instead of actual values....i again changed this to TMemoField and now it looks correct means no Chinese character....but ideally it should be TWidememoField (due to Nvarchar(max) at DB side).
Please note i have observed in one field of a Single record only and strangely when i query at SQL server side values are readable.
This is forcing me to rethink about all the process since it may be huge problem after deploying at client side...
Please suggest on this.
Strange Problem with TWideMemoField
Try to backup the table, drop it, and recreate; as well drop and recreate field objects on the client-side, and verify whether the record on the server has proper encoding now.
If this does not solve the problem, please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill the table.
If this does not solve the problem, please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill the table.