June 19th, 2002, 12:35 AM
What's wrong with TEXT size ?
Sorry, My Engish is so poor , please read the following carefuly:
I installed cygwin on my win2000, the PostgreSQL works well. I use VB and psqlODBC driver to connect the database . It seemed that all are well. When I insert a string which is beyond 8K to a TEXT column , I found the TEXT column stored some rubbish date .
The PostgreSQL is 7.2 ,
ODBC driver is 7.2.1 downloaded from http://mirrors.sunsite.dk/postgresql...07_02_0001.zip
I read some article . They told me that the length of a TEXT column is unlimited . Who can tell me What 's wrong with it.
June 19th, 2002, 10:58 PM
The text field is unlimited in length but PostgreSQL has a maximum size for each row of 8k. This is configurable to 32k but slows down the database. In your case it is needed so you will need to modify the configuration file for PostgreSQL to increase the size.
June 20th, 2002, 12:35 AM
The 8K limitation no longer exists, in latest versons of PostgreSQL (actually, for at least 2 years). See http://www.ca.postgresql.org/users-l...mitations.html
I cannot say exactly what the problem is, but you are using on several technologies here, including VB and ODBC. Have you tried just running a simple SQL query, including more than 8K, just to see if it works? (Hint: just build a text file with an SQL query of > 8K data, then run it from the command line)
If the query works, then you should check out VB and ODBC a little more.
June 20th, 2002, 08:48 AM
whenever I hear ODBC my stomach gets upside down.
June 23rd, 2002, 06:24 AM
I agree with rycamor (he is the MAN on these things) and sylow.
Try and bypass ODBC first and see what happens. Go staight to Cygwin command line and run your query before worrying about troubleshooting VB and Access.