EXTREMELY WEIRD 31 Characters in a 30 Character field

brucem
Member Posts: 86
I was doing test restores on the new sql version and have come across something dead weird.
I backed up our original db and then tried to restore the database.
On the sale shipment header table i got the error
The sales shipment header table contains a field with a code or text value that is too large for the SQL server type:
Record N.='SPS/00008'
Field Ship-to-address= 'C/O Birkart Int. Forwarders Ltd'
SQL type VARCHAR(30)
I looked in the orignal database and the field type is text 30 and the contents are 'C/O Birkart Int. Forwarders Ltd'
BUT THE WEIRD THING IS IN
C/O Birkart Int. Forwarders Ltd
There are 31 !!! characters. The table has stored 31 Characters in a 30 Character field !!!
One of the characters must be being ignored i would guess at the . or the /
any one seen this before ???
Bruce
I backed up our original db and then tried to restore the database.
On the sale shipment header table i got the error
The sales shipment header table contains a field with a code or text value that is too large for the SQL server type:
Record N.='SPS/00008'
Field Ship-to-address= 'C/O Birkart Int. Forwarders Ltd'
SQL type VARCHAR(30)
I looked in the orignal database and the field type is text 30 and the contents are 'C/O Birkart Int. Forwarders Ltd'
BUT THE WEIRD THING IS IN
C/O Birkart Int. Forwarders Ltd
There are 31 !!! characters. The table has stored 31 Characters in a 30 Character field !!!
One of the characters must be being ignored i would guess at the . or the /
any one seen this before ???
Bruce
0
Comments
-
It's dead weird indeed <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
But I would be curious to see what happen if you change the '.' and the '/' by any letter from A-Z
Let us know what were the result of your experimentation ...
tarek_demiati@ureach.com0 -
This really is weird, if i try to copy the field contents to a new record ( in table view) i get the standard navision error message about the field length being too short to accept the cut and paste operation.
Bruce0 -
We just saw this happen. It seems that a TRANSFERFiELDs
command doesn't give an error when you move to a field of
a different length in 2.5. A shipping code of 8 is comming in
with 9 characters. The From length is 9, the to length is 8.0 -
Hi Della,
Well that's a relief.. I was beginning t think that I was the only one this would / had happened to.
It would be nice if someone form Navision would comment on this...
Bruce0 -
Too many characters?
We found that while localizing NF2.50
One string in acounting period name had 11 chars while NF (c/server)claimed the field lengtht is 10!
Amazingly it is working fine on C/Server! (was working in previous versions for very long time ;-))
But.. after making backup from c./server just to restore it to MS SQL we found it is impossible to import this backup (MS SQL creates it's table fields according to c/server schema i.e. 10 characters, then it is impossible to put 11 chars in it).
BTW: We found nothing dangerous about this "feature". All you have to do is to extend field name in c/server then make a backup.
That is it.
cheers
Krzysiek
nspl0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions