Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Turkish characters dont be displayed correctly
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Turkish characters dont be displayed correctly

 Post Reply Post Reply Page  <12
Author
beyaz_seytan View Drop Down
Groupie
Groupie


Joined: 15 October 2004
Location: Turkey
Status: Offline
Points: 140
Post Options Post Options   Thanks (0) Thanks(0)   Quote beyaz_seytan Quote  Post ReplyReply Direct Link To This Post Posted: 23 December 2006 at 2:58pm
Originally posted by Tr_2007 Tr_2007 wrote:

Originally posted by beyaz_seytan beyaz_seytan wrote:

yes AND for your server out turkey can you add this in to database_connection.asp

ewet server'nizin ayarlari turkiyeye gore değil ise bunu cozemek icin database_connection.asp dosyasina bu kodlari ekeleye bilirsiniz.

Response.CharSet = "iso-8859-9"   ' ciktiyi asp den turkceye zorlamak icin.
Session.CODEPAGE = "1254" ' ASP icindeki dili turkceye cevirmek icin
Session.LCID = 1055 ' bolgesel ayarlari turkce yapmak icin.

And if Your db is MySQL charset =  latin5_turkish_ci

ve db 'niz mysql ise charset'i latin5_turkish_ci olarak belirtin
 
slmlar tam olarak nereye ne yazacağımızı txt dosyası olarak atarmısınız

add to database/database_connection.asp
<%
Response.CharSet = "iso-8859-9"
Session.CODEPAGE = "1254"
Session.LCID = 1055
%>
Response.write "Asp"
Document.write("JavaScript")
Echo("Php")
WriteIn('Pascal-Delphi')
Printf("C")

Mail & GTalk : BeyazSeytan@gmail.com
Back to Top
beyaz_seytan View Drop Down
Groupie
Groupie


Joined: 15 October 2004
Location: Turkey
Status: Offline
Points: 140
Post Options Post Options   Thanks (0) Thanks(0)   Quote beyaz_seytan Quote  Post ReplyReply Direct Link To This Post Posted: 23 December 2006 at 3:02pm
Originally posted by reberudum reberudum wrote:

selamlar beyaz şeytan bişi sormak istiyorum, senin belirttiğin metotla şuanki verilerde düzeliyormu, Şöyleki
kimyageriz.biz sitesinde kullanıyorum DB 40 MB civarında ancak yedek alamıyorum çünkü bilgisayarıma indirdiğim zaman ı=y ş=? ö=? şeklinde çıkıyor yani türkçe kqrakterlerin hepsi bozuluyor. anlamadığım serverdede aynı benimki gibi bir bilgisayardda çalışıyor neden orada tr karakterler düzgünde ben yedek alınca bozuluyorrr.
 
bunları nasıl düzeltilirim yada bozulmadan nasıl yedek alırım...
 
Server değişemiyorum değişmek istesemde ve adamlar fahiş fiyat istemeye başladılar lütfen yardım eddin bana ...

db dosyanin prblemini bilemicem ama makinendeki ofice programi yada makinende isletim systemi ile alakali ola bilir bu problem mesala ben inglizce isletim systemi kullanirken asp dosyalarinin icinde bilr turkce karaktar yazsam ayni sekilde ascii deki default karsiliklari cikmakta idi. access kullanmadim o zaman boyunca o yuzden ayni sorun ondada cikarmi bilmiyorum ama istersen normal calisan Turkce bir isletim systemi ile db ni download etmeye calis. bu sirada kullandiğin ftp programi da onemli. cunku data transferi icin kulalndiğin programda ascii char map sahibi değil ise oda benzer sorunlara neden ola bilir.
Response.write "Asp"
Document.write("JavaScript")
Echo("Php")
WriteIn('Pascal-Delphi')
Printf("C")

Mail & GTalk : BeyazSeytan@gmail.com
Back to Top
Tr_2007 View Drop Down
Newbie
Newbie


Joined: 22 December 2006
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tr_2007 Quote  Post ReplyReply Direct Link To This Post Posted: 23 December 2006 at 3:42pm

Birde forumda arada sırada bazenleri konular üstteki giriş yazısı filan şaçma sapan yazıyor yani Tr karakterden çıkıyor  üyenin mail adresine giden mesajda Tr karakteri desteklemiyor ne yapmam lazım

Back to Top
bitbyter View Drop Down
Newbie
Newbie


Joined: 04 February 2007
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote bitbyter Quote  Post ReplyReply Direct Link To This Post Posted: 05 February 2007 at 7:14pm

i convert my Webwiz 8.03 forum with access database in webwiz forum 8.05 with MS SQL server database.  converting went succesfully. the database collation is set in ms sqlserver managment to "Turkish_as_Ci"

but,  after this converting procedure members with Turkish characters in their username or password can't login. 
 
Const strPageEncoding = "iso-8859-9"  in browser_page_encoding.asp is set
Response.CharSet = "iso-8859-9"  and Session.LCID = 1055 is set in database_connection.asp.
 
adding Session.CODEPAGE = "1254"  in database_connection.asp has fixed this problem but now are the Turkish characters in posts and in the rest of the forum deformed.
  
 
who can help ? 
 
 kafayi yicem..


Edited by bitbyter - 05 February 2007 at 7:17pm
Back to Top
1980best View Drop Down
Newbie
Newbie


Joined: 21 July 2008
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote 1980best Quote  Post ReplyReply Direct Link To This Post Posted: 21 July 2008 at 2:38pm


'******************************************
'***   Open Database Connection      ****
'******************************************

'This sub procedure opens a connection to the database and creates a recordset object and sets database defaults
Public Sub openDatabase(strCon)

 'Setup database driver and defaults
 '**********************************
 
 'SQL Server Database Defaults
 If strDatabaseType = "SQLServer" Then
  
  'Please note this application has been optimised for the SQL OLE DB Driver using another driver
  'or system DSN to connect to the SQL Server database will course errors in the application and
  'drastically reduce the performance!
 
 
  'The SQLOLEDB driver offers the highest performance at this time for connecting to SQL Server databases from within ASP.
  
  'MS SQL Server OLE Driver (If you change this string make sure you also change it in the msSQL_server_setup.asp file when creating the database)
  strCon = "Provider=SQLOLEDB;Connection Timeout=90;" & strCon
  
  'The GetDate() function is used in SQL Server to get dates
  strDatabaseDateFunction = "GetDate()"
  
  'Set true and false for db
  strDBFalse = 0
  strDBTrue = 1
  
  'Set the lock variavbles for the db
  strDBNoLock = " WITH (NOLOCK) "
  strRowLock = " WITH (ROWLOCK) "
  
  'Set the Limit opertaor for SQL Server
  strDBTop1 = " TOP 1"
  
 
 'MySQL Server Database Defaults 
 ElseIf strDatabaseType = "mySQL" Then
  
  'This application requires the myODBC 3.51 driver
 
  'myODBC Driver 3.51
  strCon = "Driver={MySQL ODBC 3.51 Driver};Port=3306;Option=3;" & strCon
  
  'Calculate the date web server time incase the database server is out, use international date
  strDatabaseDateFunction = "'" & internationalDateTime(Now())& "'"
  
  'Set true and false for db (true value is -1)
  strDBFalse = 0
  strDBTrue = -1
  
  
  'Set the limit operator
  strDBLimit1 = " LIMIT 1"
  
 
 'MS Access Database Defaults 
 ElseIf strDatabaseType = "Access" Then
  
  'Database driver (Microsoft JET OLE DB driver version 4)
  strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strCon
  
  'The now() function is used in Access for dates
  strDatabaseDateFunction = "Now()"
  
  'Set true and false for db
  strDBFalse = "false"
  strDBTrue = "true"
   
  'Set the limit operator for Access
  strDBTop1 = " TOP 1"
  
 End If
 
 
 
 'Open Datbase Connection
 '***********************

 'Create a db connection odject
 Set adoCon = CreateObject("ADODB.Connection")


Response.CharSet = "iso-8859-9"
Session.CODEPAGE = "1254"
Session.LCID = 1055

 
 'Set error trapping
 On Error Resume Next
 
 'Set the connection string to the database
 adoCon.connectionstring = strCon
 
 'Set an active connection to the Connection object
 adoCon.Open
 
 'If an error has occurred write an error to the page
 If Err.Number <> 0 Then Call errorMsg("An error has occurred while connecting to the database.", "db_connection", "common.asp")
     
 'Disable error trapping
 On Error goto 0
 
 
 'Intialise the main ADO recordset object
 Set rsCommon = CreateObject("ADODB.Recordset")

End Sub

 
 
ORAYA YAPIŞTIR ÇALIŞIYOR
Back to Top
by_rehep View Drop Down
Newbie
Newbie


Joined: 23 March 2009
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote by_rehep Quote  Post ReplyReply Direct Link To This Post Posted: 24 March 2009 at 9:05pm
Originally posted by beyaz_seytan beyaz_seytan wrote:


add to database/database_connection.asp
<%
Response.CharSet = "iso-8859-9"
Session.CODEPAGE = "1254"
Session.LCID = 1055
%>


Çok sağol beyaz şeytan benim forumdada ı-ş-ö-ç felan cıkmıyordu bu kodları yazınca sitede hiç bir sorunum kalmadı :)
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.