Results 1 to 3 of 3

Thread: Ms Sql 2000 for Norweign

  1. 07-10-2003, 12:02 PM #1
    cgatto
    cgatto is offline Registered User
    Join Date
    Jul 2003
    Posts
    1

    Ms Sql 2000 for Norweign

    I've been asked to setup a db for Norweigns to use. Currently SQL is defaulting to server parameters (English). Do I have to do anything to be able to house content in the Norweign language?
    Last edited by cgatto; 07-10-2003 at 12:05 PM.
    Reply With Quote Reply With Quote
  2. 07-10-2003, 12:10 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Try this.

    SELECT *
    FROM ::fn_helpcollations()

    Then when you create a database create with this Danish_Norwegian*
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-10-2003, 12:25 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Create a database with different collation

    create database test123 collate Danish_Norwegian_CI_AI_KS

    To alter a database to different collation

    alter database test123 collate Danish_Norwegian_CI_AI


    For create tables with different collation

    http://forums.databasejournal.com/sh...hlight=collate
    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