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 |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2002-02-19 : 12:59:53
|
| Hiya!I have a varchar(6000) column which stores a SELECT string. Since the string can be very long, and Enterprise Manager is not good with typing long strings directly into the table, I use Access 2000 with a linked table. Now I have an approx. 4600 character string, which when I try to paste into the Access table, it goes, but when I refresh, the last several hundred characters are turned into question marks. Nothing is truncated, only turned into question marks.(I'm not really sure whether SQL or Access is the problem, so I'm daring to post it in the SQL forum.)Sarah Berger MCSD |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-02-19 : 13:36:59
|
| Hiya!Microsoft's site says that if you have Win2K with SP2, you do not need this update. That's my OS.Sarah Berger MCSD |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-02-19 : 13:43:51
|
| Hiya! I tried it again, and this time it went through fine. Seems I haven't tried it since I installed the SP, which was today, and my colleague was having this problem, and her machine does not have a SP.Thanks Tons!!Sarah Berger MCSD |
|
|
|
|
|
|
|
|
Storing long strings in Varchar field