Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Paul Hastings
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 inst

Issue Solved -> Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Sathyanarayanan Ramanathan
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 an

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Sathyanarayanan Ramanathan
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 Arab

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Paul Hastings
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 c

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Bobby
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" wrote: > >On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote: >> *Issue 1: *Now

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Paul Hastings
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 a

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Paul Hastings
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 a

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Bobby
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, th

Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Sathyanarayanan Ramanathan
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