UniCode (Oriental) characters

[craigtimms]

Hi there,

Using Delphi XE2, UniDac 4.6.12 and MS SQL Server 2008 R2 - I have a Delphi form with 3 x TMemo components - and I have 3 db fields:

T_TICKETDESCRIPTION: TWideMemoField;
T_TICKETREMARKS: TWideMemoField;
T_TICKETINSTRUCTIONS: TWideMemoField;

when I do the following:

dm.T_TICKETDESCRIPTION.Assign(MemoDescription.Lines);
dm.T_TICKETREMARKS.Assign(MemoRemarks.Lines);
dm.T_TICKETINSTRUCTIONS.Assign(MemoInstructions.Lines);

the db record contains unicode? or oriental looking characters

how can I fix this?

[AndreyZ]

Hello,

SQL Server allows storing Unicode characters only in the nchar, nvarchar, and ntext types. This is a specificity of SQL Server work with Unicode. Please make sure you are using these types to work with Unicode characters. If you are using these types, SQL Server stores correct Unicode characters.