October 21, 2005 at 3:02 pm
What would cause a cfm application quering a SQL server 2000 to return book tittles from the same table correctly for every language other than arabic. It jsut returns a string of ????? (question marks). The database is set to arabic and the windows 2000 server has the latest MDAC and arabic is enabled. Anyone every see this? Thanks!
October 21, 2005 at 5:19 pm
First make sure where the problem is: what happens when you run the query in Query Analyzer?
I suspect it is not a SQL Server problem but likely on the client side (probably a browser based application?)"
October 25, 2005 at 11:49 am
This is correct. It will display correctly from Query Analyzer but when the Query is done through an application it will only display ??????. Arabic is one of the supported languages on teh server though, They have other info on the server that is writen in arabic that displays fine. Just wont display correctly when the content is being queried through an application. Thanks!
October 25, 2005 at 12:31 pm
Is it a web site, in other words is the client a web browser? Are you sure the client can show arabic characters?
October 25, 2005 at 12:47 pm
ya this is a website and the results of the query are displayed ian a browser. They have content that is in may languages and the query works for all languages othere than arabic. CTO says this is a problem with the MDAC and unicode, but then why do all the other languages display properly. Thanks!
October 25, 2005 at 4:28 pm
But is any of those "many languages" that are displayed correctly written right-to-left? I think the client needs to have the proper language files installed. Check in Control Panel, Regional Settings, Language tab. There is a check box that says whether or not these language files are installed.
October 25, 2005 at 4:57 pm
Yes the default is Western Europe and United States and then you go under advanced and "code page conversion tables" all are selected. I also see that 1256 ansi arabic is a light shade of gray and is checked adn will not let me uncheck it? Would this mean that is a default or not installed? Thanks!
October 26, 2005 at 12:16 am
That was not what I was referring to. In my Regional Settings (I am running Win XP Pro English) I select the Languages tab (not Advanced). There is an option called "Install files for complex script and right-to-left languages (including Thai)". Is checked that option checked?
October 27, 2005 at 9:06 am
Okay I installed the following on my XPpro and still get the samething. Thanks!
October 28, 2005 at 8:11 am
Well ,I'm sorry but I am out of specific ideas now. But it seems fairly certain that the issue lies within the CFM application, so you should start there.
October 28, 2005 at 8:40 am
It is actually a very simple application.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
</head>
<body>
<cfquery name="getdata" datasource="dbsamir">
Select * from livreara
</cfquery>
<font size="4">
<cfoutput query="getdata">#isbn#, #title#, #saleprice#<br></cfoutput>
</font>
</body>
</html>
Thanks!
October 28, 2005 at 9:45 am
Yes, looks pretty simple alright. But like I said, I really have no experience with ColdFusion so I do not know what kind of configuration you can do with it. For all I know it might even be as simple as CF does not support Arabic characters.
October 28, 2005 at 1:00 pm
I have set up a completely diffrent application that is ASP code and get the same results. Anyother suggestions would be appreciated. Thanks!
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply