I have problem with displaying russian characters from ms sql database. I managed to properly display it using TADOConnection but not with TZConnection (which I prefer).
Delphi XE5
Zeos 7.1.2
MS SQL Server 2008
Here is my table
Code: Select all
CREATE TABLE [dbo].[DUMMY](
[ID] [int] IDENTITY(1,1) NOT NULL,
[NAME] [varchar](100) NULL,
[ENGLISH] [varchar](100) NULL,
[RUSSIAN] [nvarchar](255) NULL,
CONSTRAINT [PK_DUMMY] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
Code: Select all
INSERT INTO DUMMY VALUES ('NAME', 'ENGLISH', 'русский')
In Delphi XE5 I placed TZConnction, TZTable, TDataSet and TDBGrid.
I use mssql protocol for TZConnection (which requires ntwdblib.dll)
and link it altogether and set up all properties.
Insted of русский I got ????????.
If I use TADOConnection and TADOTable everything is fine.
I'm out of idea. Please help.
Thanks