Results 1 to 3 of 3

Thread: Tu

  1. 05-09-2003, 01:29 PM #1
    pollyjean
    pollyjean is offline Registered User
    Join Date
    May 2003
    Location
    Turkey-Ankara
    Posts
    1

    Unhappy Tu

    Hi,

    I'm a designer living in Turkey. I've designed a search engine site and worked with an asp developer. Our Database is MS SQL 2000. But I'm really in a big trouble that although our site has finished a long time ago, we could'n go online because the database does not show Turkish characters (I mean when we enter Turkish info into the database, Turkish characters can't be seen).
    The help desk of hosting company says "Tell us which collation you want and we will make it". I have been searching about "collations" for along time but I couldn't find the right collation for Turkish. My deadline has expired. So I have to find it very quickly. Is there anybody who has an idea about this problem?

    thank you
    Reply With Quote Reply With Quote
  2. 05-09-2003, 01:42 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Tried code page '1254', locale id '0x41f', collation designator 'Turkish'?
    Reply With Quote Reply With Quote
  3. 05-09-2003, 03:06 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    some more tip

    your database should have nvarchar
    datatype and when you query it through IE make sure you added turkish font.

    In order to see the turkish character in query anaylser change the font to turkish 'result' and 'grid'.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules