| Author |
 Topic  |
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
 Posted - 04 March 2004 : 13:55:27
|
I've recently done an export from my host db to another db but for some reason I have lost unicode characters in the new db. All the structure is the same, ntext, nvarchar etc.
Has anyone got any ideas what could be wrong? |
The UK MkIVs Forum |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 05 March 2004 : 07:01:41
|
different db, instance.
sql server to msde2000, same collation.
It's IE that shows the info. Sorry, it's the Snitz forum if I didn't make that clear |
The UK MkIVs Forum |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 05 March 2004 : 09:19:08
|
| Yes, but I can't enter the characters either, eg in a new post |
The UK MkIVs Forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 March 2004 : 09:20:13
|
quote:
Originally posted by DavidRhodes
Yes, but I can't enter the characters either, eg in a new post
But are they correctly stored in the MSDE database, at least those from the posts previous to the copy? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 05 March 2004 09:20:40 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 05 March 2004 : 11:24:08
|
I copied the objects
All Tasks >> Export Data
I might do a full backup and restore it on the new db to see if that works |
The UK MkIVs Forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 March 2004 : 11:32:20
|
quote:
Originally posted by DavidRhodes
I copied the objects
All Tasks >> Export Data
I might do a full backup and restore it on the new db to see if that works
Yes, I would suggest that you do that, indeed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
Posted - 06 March 2004 : 12:20:11
|
Just curious, why do you want to use MSDE2000 with Snitz?
Like its predecessor, MSDE, MSDE 2000 has a built-in performance degrader after five users connect.....
Can you do a restore in MSDE2000 with a backup from SQL server? Think I have read somewhere that MDSE lack this feature, but not sure.... |
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
Edited by - NorwegianViking on 06 March 2004 12:21:33 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 06 March 2004 : 15:05:18
|
MSDE and Sql Server share exactly the same database engine so you can do the same things. It's 25 concurrent connections but i'll take that risk!
Ruirib, my forum is currently running now at www.uk-mkvs.net , if you look at the home page you can see what I mean be the characters, one of the titles under "News" on the left and under the main story picture.
I did an export data using the wizard again rather than a backup and restore and obviously still have the same problem as above. |
The UK MkIVs Forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 March 2004 : 12:29:39
|
quote:
Originally posted by DavidRhodes
I did an export data using the wizard again rather than a backup and restore and obviously still have the same problem as above.
That's why I suggested a backup and restore. My only explanation for that situation would be that DTS is causing it. With a backup and restore, DTS would be removed from the equation.
I have exported Unicode data before, without problems. Never had MSDE as destination though. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 07 March 2004 : 12:49:39
|
I've managed to fix the characters on my home page, i'm not really bothered about any others so will leave it at that. Cheers for the advice  |
The UK MkIVs Forum |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 March 2004 : 12:51:55
|
quote:
Originally posted by DavidRhodes
I've managed to fix the characters on my home page, i'm not really bothered about any others so will leave it at that. Cheers for the advice
Just curious... what did you do?
P.S: Just asking because there are still some weird chars in some news... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 07 March 2004 12:56:50 |
|
|
|
Topic |
|
Topic Locked
