如何在水晶报告上显示阿拉伯语？ [英] How to show arabic language on crystal report ?

问题描述

我在水晶报告上显示阿拉伯语有问题，它显示为??????

我正在使用SQL作为数据库。 ..

请注意阿拉伯语在SQL和2017视觉工作室上很好地显示



我尝试了什么：



当我试图将类型从varchar50更改为nvarchar50时，当我命令保存时给我这个按摩

正在保存更改是不允许的。您所做的更改需要删除并重新创建以下表。您已经对无法重新创建或启用的表进行了更改，该选项会阻止保存需要将表更改的表重新创建

i have a problem on showing the Arabic language on crystal report it's show as "??????"
and i am using the SQL as database ...
note that the Arabic language is shown well on SQL and the visual studio 2017

What I have tried:

when i tried to change the type from varchar50 to nvarchar50 it's give me this massage when i order to save
"saving changes is not permitted . the changes you have made require the following tables to be dropped and re-created. you have either made changes to a table that can't be re-created or enabled the option prevent saving changes that require the table to be re-created "

推荐答案

SQL将不允许您使用表的设计模式更改SSMS中的数据类型 - 您将获得上述消息。

您可以使用TRANSACT更改数据类型 - 特别是使用Alter Table，Alter Column。

例如，以下操作可以在不丢失数据且不丢弃和重新创建表的情况下工作;

SQL will not allow you to change the data type in SSMS using Design mode of a Table - you will get the message as above.
You can change the datatype using TRANSACT though - specifically using Alter Table, Alter Column.
For instance, the following does work without loss of data and without dropping and recreating the table;

 -- Create a demo table
CREATE TABLE [dbo].[VToNVTest]
(
	[RecordId] INT IDENTITY(1,1) NOT NULL,
	[DemoText] VARCHAR(50) NULL,
	CONSTRAINT [PK_VToNVTest] PRIMARY KEY CLUSTERED
	(
		[RecordId] ASC
	)
	WITH
	(
		PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
		IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON
	) ON [PRIMARY]
) ON [PRIMARY]
GO
-- insert 2 records
INSERT INTO [dbo].[VToNVTest]
([DemoText])
VALUES
('Test A'), ('Test B')
GO
-- view data
SELECT * FROM [VToNVTest]

-- Change column type to NVARCHAR
ALTER TABLE [dbo].[VToNVTest]
	ALTER COLUMN [DemoText] NVARCHAR(50)
GO
-- view data
SELECT * FROM [VToNVTest]

For Crystal要正确显示数据，您需要更改列类型&正确设置字体&您可能需要更改数据库的整理



亲切的问候

For Crystal to display the data correctly you will need to change the column type & set the font correctly & you may need to change the collation of the database

Kind Regards

这篇关于如何在水晶报告上显示阿拉伯语？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！