*sara
|
| Posted: 10/24/2002, 2:37 AM |
|
hii
im using ms sql data base im my web site my problem is that i used arabic language in my web site and i stored my information in the data base in arabic put when i connect tha data base and start retreving data it appears as agrabej
how can i modify the connection so that i can retreve arabic
Dim cn : Set cn = Server.CreateObject("ADODB.Connection")
'-------------------------------
' Create database connection string, login and password variables
'-------------------------------
Dim strConn, strLogin, strPassword
strConn = "Provider=SQLOLEDB.1;Initial Catalog=ksaguide;Data Source=back1.atheer.net.sa"
strLogin = "ksaguide"
strPassword = "*****"
'-------------------------------
' Open the connection
'-------------------------------
cn.open strConn, strLogin, strPassword
'-
|
|
|
 |
el sayyid
|
| Posted: 11/13/2002, 1:35 AM |
|
did you solve this problem ? if did you can give me the solution
thanks
|
|
|
|
Nicole
|
| Posted: 11/14/2002, 6:34 AM |
|
Sara,
You shouldn’t do anything to connection to make site display national characters. Here is couple of tips that should help.
Select site NATIONAL translation in menu Tools->Options->Site Translations. In this case all site html pages should get NATIONAL charset=< NATIONAL charset>
Please check it for generated site.
If it won’t help you can try other national encoding. To apply it create second NATIONAL translation file in ../CodeCharge/Translation folder. Just copy existing NATIONAL.xml and give it other name. Then open it and replace encoding=" NATIONAL charset" with encoding=" NATIONAL charset". Select this translation for site and regenerate it.
Charset options are available at: http://msdn.microsoft.com/library/default.asp?url=/work...nce/charset.asp
As you use ASP try to play around turning on and off 'Use Custom HTML Encoding' flag on Site Properties/Database tab.
And you can add national LCID to each page using following code in Open Any Page event under Site Modules section:
Session.LCID= value
|
|
|
|
wels
|
| Posted: 02/07/2003, 2:51 PM |
|
I tryed to create the Arabic.xml or national.XML but the installation that I have doesnt have the transelation folder under the main (CodeCharge) directory , are thiese instructions goes for both CodeSharge, and Codfe charge studio ?
|
|
|
|
|
