On Sat, Aug 12, 2006 at 02:10:32PM -0600, Richard Greenwood wrote: > I can not answer your specific question, but I can say that I am able > to connect to Postgres tables via ODBC with char and varchar columns. > You have a current postgres odbc driver? Does that table open > corrrectly in e.g. Acccess or some other WIndows db software? Could be > a character encoding issue.
I changed the data type fron character(30) to varchar(30) on the 'name' field and then I was able to load it into MapInfo. I was able to modify the integer and float type fields, but not the character field 'name'. I checked the table sturcture and it showed the name field as being 60 characters instead of 30. Yes, that looks like an encoding problem. So I rebuilt the database using the 'createdb -E LATIN1 test' command and then repopulated my table with a CREATE TABLE and COPY FROM... command, and got the same result. The 'name' column is not editable, while the other columns are, and the table structure shows it to be 60 characters wide instead of 30. It still looks very much like an encoding problem to me too. So how do I fix it? I then tried loading it via ODBC into Access. I had to create a unique index first, but when I did this, I was able to load it in MS Access and everything was editable. However, even with the index, when I load it via ODBC into MapInfo, character fields are still not editable. Even though I specified ISO 8859-1 encoding when I created the database, do I also have to specify it creating each table? I'm using the 8.0.8 version of Postgres and the ODBC driver (so even though it's up to 8.1.4 now, I think it should still work if all the components are of the same vintage.) Anyway, I still don't know why this doesn't work. BTW, Richard, your "chicken cam" at http://www.greenwoodmap.com/chickencam/ is a big hit in our offices. One of the guys here raises goats and chickens, but we all got a kick out of seeing your chickens strutting in front of the web cam every once in a while! You have world-famous chickens! (Are you going to tell them?) _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
