At 17.45 23/06/2002, you wrote: >Thanks for your response. Not to sound like a total newbie, but since I am >relatively new to Linux and Postgres, can you give me a clue where I might >look for this setting? Is this in a conf file somewhere, or is it in files >that I then need to (re)compile?
If I remember rightly you need to compile unixodbc after changing unixODBC-2.2.1/Drivers/Postgre7.1/psqlodbc.h At the end of the file you find: /* sizes */ #define TEXT_FIELD_SIZE 16380 /* size of text fields (not including null term) */ #define NAME_FIELD_SIZE 32 /* size of name fields */ #define MAX_VARCHAR_SIZE 254 /* maximum size of a varchar (not including null term) */ Using this driver I suggest you to use <cfqueryparam> in SQL INSERT, otherwise special chars are not properly ecaped :-( Anyone knows if there are the same problems with cfmx, jdbc and PostgreSQL? -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
