Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Location
    Sweden
    Posts
    11

    Question Unanswered: Importing from dBase

    I'm trying to import a dBase database to SQL Server, but it contains Swedish characters (,,), and these are replaced with other characters.

    I've tried importing from dBase 5, III, and IV, without luck. I don't know how to solve this problem. Is there any way to replace characters using T-SQL, or do I need to change some settings?

    I hope someone can help me with this...

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Have you tried using Swedish collation on sql server?
    It will also depend on how you are doing the import. It may be losing the data on the extract from dbase or on the import into sql server.

  3. #3
    Join Date
    Jan 2002
    Location
    Sweden
    Posts
    11
    Thanks for your reply!

    I tried changing the collation using this:

    alter database TEST COLLATE Finnish_Swedish_CS_AS

    It didn't work. I got an error message saying:

    "Incorrect syntax near 'Finnish_Swedish_CS_AS'."

    I've used the syntax described in Books Online.

    *confused*

  4. #4
    Join Date
    Jan 2002
    Location
    Sweden
    Posts
    11
    I just learned that collation only can be changed in Sql Server 2k, so I'll solve it in another way. Thanks anyway.

Posting Permissions

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