| Author |
 Topic  |
|
|
jasonhuber
Starting Member
United States
6 Posts |
 Posted - 07 December 2007 : 17:12:18
|
I upgraded from Access to SQL Server Express.
When I look at the data everything is ok. But when I view any old posts the message is a square.. It doesnt show the words, but rather a square.
It looks to be a data conversion problem, but again the data is fine and new posts are going in and coming out ok as well.
Signatures as well...
OK well as I typed this I had some ideas, so now I am posting FYI... It looks like if the datatype gets set as nvarchar(MAX) or varchar(MAX) this happens. I tried editing the code, adding characters on etc... Nothing.. The connectionstring I am using is SQL Native client (that might also be an issue).
So change the MAX to 2000 in most cases, 500 for sigs etc and you are set
(Edited..) Change the nvarchar(MAX) to text. There are some constraints created that need to be deleted as well, but doing this will ensure really long posts arent truncated. I had some posts longer than 2000 chars, longer than 4000 chars in fact and text is the data type needed. It was too late since the tool chooses this for you, but MAX didnt lose any data, it just doesnt display. Setting it to text works great.
(Edited again) in case someone else finds this post and is looking to go from access to SQL server (2005) check out this post: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884 (thanks AnonJR) it has some logical steps that would have saved me a lot of time. |
Edited by - jasonhuber on 12 December 2007 08:16:11 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 08 December 2007 : 17:04:18
|
| Maybe you've hit a codepage/collation/etc issue? |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 11 December 2007 : 21:21:01
|
If he seems a little short its only because there are numerous topics on upgrading - yet most people do not do their "due diligence" and end up with problems. Even then there are people who do find the topic ignore the advice because they think its either too much work or they think we are purposely making it hard. (Neither is the case) So forgive us a little sharpness on the "perennial issues" ... 
This is the most detailed (and therefore the longest) topic on the subject: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884 |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 12 December 2007 : 03:09:10
|
AnonJr:
this is normal to the fellows that only post topics before even search for some kind of direction in other topics that might already been open in the Forum 
so... for that, I have no petty for such persons  |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 12 December 2007 : 07:05:51
|
quote:
Originally posted by balexandre
AnonJr:
this is normal to the fellows that only post topics before even search for some kind of direction in other topics that might already been open in the Forum
so... for that, I have no petty for such persons
I normally don't have much pity either, and I've not always been the most polite. But, sometimes I do wonder at the collateral damage this causes - the people who might pass us by because the support seems "rude" despite their not seeing the context. And then there are times I'm just so blindingly frustrated with said stupid poster that I fire off a reply without thinking of much else...  |
|
|
|
jasonhuber
Starting Member
United States
6 Posts |
Posted - 12 December 2007 : 08:06:16
|
quote:
Originally posted by AnonJr
If he seems a little short its only because there are numerous topics on upgrading - yet most people do not do their "due diligence" and end up with problems. Even then there are people who do find the topic ignore the advice because they think its either too much work or they think we are purposely making it hard. (Neither is the case) So forgive us a little sharpness on the "perennial issues" ...
This is the most detailed (and therefore the longest) topic on the subject: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884
Thanks for the link. I assure you I did search for the topic and I am not afraid of a little work. You are right that is what I needed. It would have saved me some time and lost data that I had to recover. And it does make sense to let Snitz create the forum for you then just pull in the data. |
Edited by - jasonhuber on 12 December 2007 08:18:46 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 December 2007 : 08:26:36
|
| Well maybe you could have shown some interest in knowing what we advise. And a simple search with 3 nice keywords (Access SQL Server) would bring you the posts you need. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
jasonhuber
Starting Member
United States
6 Posts |
Posted - 12 December 2007 : 08:29:16
|
Sorry guys, decided to take a look at myself and rethink my posts (You are a good example AnonJr)
Thanks for the help (AnonJr), my next upgrades will go easier!
Ill try and do a better job at searching next time - it would have saved me some work! |
|
|
| |
Topic |
|
Topic Locked
