var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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...
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.
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.
I just learned that collation only can be changed in Sql Server 2k, so I'll solve it in another way. Thanks anyway.