Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-05 : 08:51:45
|
| Eowyn writes "Hi!I have imported an HP3000 database into Sql Server 7.0 and å,ä,ö becomes [ ] \ - what can I do to correct this?" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-12-06 : 05:47:46
|
| Hi!I have no experience of how the HP3000 database looks, but I have experience of the problem from other platforms. In some cases if you are importing via ODBC you can set some setting which corrects the problem. In some cases I've had to script a replacement routine (ActiveX vbscript using DTS) to replace the unwanted characters with correct ones. |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2001-12-06 : 06:20:07
|
| Sounds like you're coming from a platform that's using ISO 646.SEThat's the obsolete Swedish national version of (7-bit) ASCII, which actually replaced the \[]{}~ etc. characters with additional letters. But the particular mappings you mention don't seem quite right.http://www.kostis.net/charsets/iso646.se.htmAll the characters in ISO 646.SE are in ISO 8859-1, so you should be able to keep a 1-byte character representation of the data. Of course, if some of the data was entered on the basis of ISO 646.SE and some as ASCII, then you could have problems, but nothing that wasn't already in the database.Edited by - Arnold Fribble on 12/06/2001 06:24:47 |
|
|
|
|
|
|
å,ä,ö becomes [ ] \