Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue Solved - Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear Friends, Finally the is solved. Thanks Bobby Paul. While adding datasource in CF administrator , in server field I was wrongly trying as localhost, now I changed to MICRO\SQLEXPRESS as server and db name in database field along with check box checked for Enable High ASCII characters and Unicode for data sources configured for non-Latin characters. This solved the issue. Now am able to successfully connect CF9 with SQL server 2008 and Arabic text is displaying as well. Your valuable time help is really appreciated. Thanks, Sathya.R On Thu, Aug 7, 2014 at 10:34 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
On 8/7/2014 1:34 PM, Sathyanarayanan Ramanathan wrote: Yes. I was using ODBC socket datasource to connect CF with SQL server well you can stop now. Driver]Error establishing socket to host and port: 127.0.0.1:1433. use real IP or server name instead of 127.0.0.1. if you're using an instance, make sure you add that for the server name, bangkok\sqlexpress for example. also double check username/password (won't see that authentication error until server name issue is resolved). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear Friends, Few days before I was trying to insert Arabic text into my ColdFusion application with oracle database. And finally it worked for me as I mentioned in previous mail chain below. *Steps taken:* *Oracle side:* I created the new database with NLS_CHARACTERSET as AL32UTF8 and imported my old exported database having different characterset. *CF side:* I added the below two lines at the top of the cfm template. meta http-equiv=Content-Type content=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 *Current Issue:* But now am facing similar issue with respect to insert Arabic text into my ColdFusion application with SQL Server 2008 database. *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in some table columns. But when I try to fetch display using CF even after adding charset in meta tag cfprocessingdirective as UTF-8 all Arabic text appeared as . But if I use charset as Windows-1256 static text in the cfm page such as column headers are coming as Arabic. But the fetched data from sql db still appear as ??? Please help. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Last time, my suggestion was to make sure the Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² setting was enabled on your CF datasource but that was before I realized it was an oracle datasource. If you are using a SQL Server datasource this time, that setting should apply so make sure the setting is enabled and try it again. On 8/6/14, 9:17 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear Friends, Few days before I was trying to insert Arabic text into my ColdFusion application with oracle database. And finally it worked for me as I mentioned in previous mail chain below. *Steps taken:* *Oracle side:* I created the new database with NLS_CHARACTERSET as AL32UTF8 and imported my old exported database having different characterset. *CF side:* I added the below two lines at the top of the cfm template. meta http-equiv=Content-Type content=text/html; charset=utf-8 cfprocessingdirective pageencoding=utf-8 *Current Issue:* But now am facing similar issue with respect to insert Arabic text into my ColdFusion application with SQL Server 2008 database. *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in some table columns. But when I try to fetch display using CF even after adding charset in meta tag cfprocessingdirective as UTF-8 all Arabic text appeared as . But if I use charset as Windows-1256 static text in the cfm page such as column headers are coming as Arabic. But the fetched data from sql db still appear as ??? Please help. Sathya.R ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
On 8/6/2014 8:28 PM, Bobby wrote: Last time, my suggestion was to make sure the Enable High ASCII characters and Unicode for data sources configured for non-Latin characters� setting was enabled on your CF datasource but that was before I realized it was an oracle datasource. If you are using a SQL Server datasource this time, that setting should apply so make sure the setting is enabled and try it again. will only have effect on cfqueryparam. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote: *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in some table columns. But when I try to fetch display using CF even after adding charset in meta tag cfprocessingdirective as UTF-8 all Arabic text appeared as . ?? means your text data is garbaged from the db. double check that it's stored in an N datatype (nchar, nvarchar, etc.). then double check if the data is in fact encoded as unicode. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? On 8/6/14, 12:21 PM, Paul Hastings p...@sustainablegis.com wrote: On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote: *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in some table columns. But when I try to fetch display using CF even after adding charset in meta tag cfprocessingdirective as UTF-8 all Arabic text appeared as . ?? means your text data is garbaged from the db. double check that it's stored in an N datatype (nchar, nvarchar, etc.). then double check if the data is in fact encoded as unicode. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm