Is there a Help Document on Rules For Text Strings and their formats in Text fields in dbf files?
I have to do a lot of merging of files with a text string field and all to frequently I get error message 001156 regarding something in the text string I put in the text field and I go bonkers trying to figure out what it is. I have been able to figure some things on my own but this is still a pain in the butt to have to go through. I have tried various queries in Help but nothing gets at what I'm talking about.
I have been able to fix errors like the ones below in the past (consistent character string recognition from one database to another) but then when I thought I'd figured it out things like the ones in the pics still come up.
Also: Why is it when I am adding a Text field to a dbf file if I indicate a certain number of characters, after it becomes a part of the dbf file, it automatically goes to 255, even if I use the default of 50 when I am initially naming the Text field???
As in, why should I have to indicate what my field length is when I get this instead?