yes okay, i jumped in without putting on my Speedo's. obviously 1 byte is used for each character or whatever, and i'm sure the answer can be found with a little research, but i was trying to think of why there is a nominal figure of 255 given as to the number of characters available within a text field, and i assumed it was something along the lines of a byte being able to store a number between 0 and 255, thus Access assigns 1 byte to store the SIZE of the field, hence my wonderings as to why MapInfo can only do it up to 254, and that could be something to do with the Option Base, where MapInfo may begin it's numbering at zero instead of one.
then again, i could know absolute jack. ash -----Original Message----- From: Mats Elfstr�m [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 September 2002 3:13 PM To: Simmonds, Ashley (PTB) Subject: SV: MI-L 255 character text fields in Access ...access uses 1 byte to store 255 characters. Amazing - how is that done? ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :Email/ [EMAIL PROTECTED] ICQ#9517386: :---------------------------------------------------------------------: :Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN: :Phones: +46 46 145959, +46 70 595 3935 : ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: -----Ursprungligt meddelande----- Fr�n: Simmonds, Ashley (PTB) [mailto:[EMAIL PROTECTED]] Skickat: den 10 september 2002 06:53 Till: [EMAIL PROTECTED] �mne: RE: MI-L 255 character text fields in Access no real answers here, but in the help MapInfo actually says that a Char field has a maximum of 250 alphanumerics, strange. i'm not sure where the number comes from, as access uses 1 byte to store 255 characters, so you would assume other programs could also store the same amount of information within the same data parcel size, but maybe MapInfo requires just that little bit extra to store stuff. sorry, that's of no help. i don't use the ODBC stuff with mapinfo/access, (my ODBC options are in mexican for some reason) preferring to get what i need from mapinfo through VB, so apart from going through all your tables and making them compatible with MI, code evaluations may be the only answer. perhaps just an adelaide phenomenon. ash -----Original Message----- From: Chris Prescott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 September 2002 1:43 PM To: [EMAIL PROTECTED] Subject: MI-L 255 character text fields in Access Hi, In Access the length of a text field is from 0 to 255 characters but in MapInfo it is 1 to 254 characters. If you open an Access table in MapInfo (using ODBC) all text fields that are defined at 255 characters are opened as Read-Only. Fields that are 254 characters or less in length are editable (assuming that all requirements for editable ODBC tables are met). Why is there an inconsistency between Access & MapInfo's text fields and how can I make a 255 character field in Access editable in MapInfo (and please don't tell me to make them 254 chars) ? Thanks, Chris CHRISTOPHER PRESCOTT GIS Specialist TONKIN CONSULTING 5 Cooke Terrace Wayville SA 5034 T +61 8 8273 3100 F +61 8 8273 3110 E [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2923
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2924
