Turkish Character Problem with ASP

I use :

   SQL Server 7.0 (with ODBC Connection)
   ASP in my web site (with ADODB object)

  and I have a problem about turkish characters. Database converts these characters (?,y,Y,..) to other english versions (?,y,..).
 I'm sure that these problem about SQL Server. Example I put some data from my computer to this remote sql server with MS Access and I see this same problem.
 
 Hosting firm said to me "these problem about your asp codes not about sql server" , but I'm not sure that..

How can I fix these problem?


Thanks.
kul1000Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Did you define the column datatype as NVARCHAR?
0
 
kul1000Author Commented:
hehehe I see that these site have same problem...
0
 
kul1000Author Commented:
yess.. when I see this solution then you answer to me..

thanks a lot..
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Glad if i could help...
Cheers
0
All Courses

From novice to tech pro — start learning today.