I am using Crystal Reports 10. The reports are obtaining data from an Oracle 10G database. We have some data in Arabic. When I try to display the Arabic data it is showing as ?.
我正在使用Crystal Reports 10.报告从Oracle 10G数据库获取数据。我们有一些阿拉伯语的数据。当我尝试显示阿拉伯数据时,它显示为?
Any ideas on what I can do to display this correctly?
关于我能做些什么来正确显示这个的想法?
4 个解决方案
#1
4
I've never used crystal reports and my oracle knowledge is limited, however I've done some work in Arabic. Things to look out for.
我从来没有使用水晶报告,我的oracle知识是有限的,但我做了一些阿拉伯语的工作。值得关注的事情。
Does the Database have the arabic locale installed can it display right to left text.
数据库是否安装了阿拉伯语语言环境,是否可以显示从右到左的文本。
Under windows check the languages settings and check that the option to include support for left to right writing systems is installed.
在Windows下检查语言设置,并检查是否安装了包含从左到右书写系统支持的选项。
Check that your database is the international version and not one that only supports the latin character set. It may be that there is a problem converting between ASCII and Unicode.
检查您的数据库是否为国际版本,而不是仅支持拉丁字符集的数据库。可能是在ASCII和Unicode之间转换时出现问题。
Arabic Characters are not on the same ASCII code page as the Latin Character set your machine will be used to using, there might be a special version of crystal reports that supports arabic.
阿拉伯字符与您的机器将使用的拉丁字符集不在同一个ASCII代码页上,可能有一个支持阿拉伯语的特殊版本的水晶报表。
Check that the machine you are running crystal reports on has the arabic locale/fonts installed on it.
检查运行水晶报告的机器是否安装了阿拉伯语语言环境/字体。
UPDATE
I've Had a quick look on the internet and you might want to look at this link
我已经快速浏览了一下你可能想看看这个链接
Here is a summary:
以下是摘要:
This issue can be solved when you create the reports without needing to write any extra code. I haven't tested this solution because I don't have any data to test it against.
创建报告时无需编写任何额外代码即可解决此问题。我没有测试过这个解决方案,因为我没有任何数据来测试它。
First you want to make sure that you are using a UNICODE font which I'm sure you are probably already doing. Then to configure the "Right to Left" you can right click on any field and select "Format Text" or "Format Field". You should see a "Paragraph" tab. In there you can set the content to be "Left to Right" or "Right to Left". The button on the right allows you to make this setting conditional on a parameter value or something like that. I hope this helps.
首先,您要确保使用UNICODE字体,我相信您可能已经在使用它。然后,要配置“从右到左”,您可以右键单击任何字段,然后选择“格式文本”或“格式字段”。您应该看到“段落”选项卡。在那里,您可以将内容设置为“从左到右”或“从右到左”。右侧的按钮允许您根据参数值或类似值进行此设置。我希望这有帮助。
#2
1
Right Click on field > Format Object > Paragraph then Reading Order Right to left
右键单击字段>格式对象>段落,然后从右到左阅读顺序
#3
0
- Make sure you have Arabic support installed in Windows.
- Add the correct LANG and NLS_LANG to your registry (for me it's ARABIC__QATAR.AR8MSWIN1256)
确保在Windows中安装了阿拉伯语支持。
将正确的LANG和NLS_LANG添加到您的注册表中(对我而言,它是ARABIC__QATAR.AR8MSWIN1256)
#4
0
right click on your data base and select properties then select options then change collation to Arabic_CI_AS
右键单击数据库并选择属性,然后选择选项,然后将排序规则更改为Arabic_CI_AS
#1
4
I've never used crystal reports and my oracle knowledge is limited, however I've done some work in Arabic. Things to look out for.
我从来没有使用水晶报告,我的oracle知识是有限的,但我做了一些阿拉伯语的工作。值得关注的事情。
Does the Database have the arabic locale installed can it display right to left text.
数据库是否安装了阿拉伯语语言环境,是否可以显示从右到左的文本。
Under windows check the languages settings and check that the option to include support for left to right writing systems is installed.
在Windows下检查语言设置,并检查是否安装了包含从左到右书写系统支持的选项。
Check that your database is the international version and not one that only supports the latin character set. It may be that there is a problem converting between ASCII and Unicode.
检查您的数据库是否为国际版本,而不是仅支持拉丁字符集的数据库。可能是在ASCII和Unicode之间转换时出现问题。
Arabic Characters are not on the same ASCII code page as the Latin Character set your machine will be used to using, there might be a special version of crystal reports that supports arabic.
阿拉伯字符与您的机器将使用的拉丁字符集不在同一个ASCII代码页上,可能有一个支持阿拉伯语的特殊版本的水晶报表。
Check that the machine you are running crystal reports on has the arabic locale/fonts installed on it.
检查运行水晶报告的机器是否安装了阿拉伯语语言环境/字体。
UPDATE
I've Had a quick look on the internet and you might want to look at this link
我已经快速浏览了一下你可能想看看这个链接
Here is a summary:
以下是摘要:
This issue can be solved when you create the reports without needing to write any extra code. I haven't tested this solution because I don't have any data to test it against.
创建报告时无需编写任何额外代码即可解决此问题。我没有测试过这个解决方案,因为我没有任何数据来测试它。
First you want to make sure that you are using a UNICODE font which I'm sure you are probably already doing. Then to configure the "Right to Left" you can right click on any field and select "Format Text" or "Format Field". You should see a "Paragraph" tab. In there you can set the content to be "Left to Right" or "Right to Left". The button on the right allows you to make this setting conditional on a parameter value or something like that. I hope this helps.
首先,您要确保使用UNICODE字体,我相信您可能已经在使用它。然后,要配置“从右到左”,您可以右键单击任何字段,然后选择“格式文本”或“格式字段”。您应该看到“段落”选项卡。在那里,您可以将内容设置为“从左到右”或“从右到左”。右侧的按钮允许您根据参数值或类似值进行此设置。我希望这有帮助。
#2
1
Right Click on field > Format Object > Paragraph then Reading Order Right to left
右键单击字段>格式对象>段落,然后从右到左阅读顺序
#3
0
- Make sure you have Arabic support installed in Windows.
- Add the correct LANG and NLS_LANG to your registry (for me it's ARABIC__QATAR.AR8MSWIN1256)
确保在Windows中安装了阿拉伯语支持。
将正确的LANG和NLS_LANG添加到您的注册表中(对我而言,它是ARABIC__QATAR.AR8MSWIN1256)
#4
0
right click on your data base and select properties then select options then change collation to Arabic_CI_AS
右键单击数据库并选择属性,然后选择选项,然后将排序规则更改为Arabic_CI_AS