I am accessing a Microsoft Access 2000 database using the Unified ODBC functions. My problem is that some SQL field types are not recognised and cause the database driver to a (generic) syntax error. For instance

odbc_exec($odbc,'CREATE TABLE FormData (formid LONG,dataphp LONG VARCHAR)');

...does not work because of "LONG VARCHAR". I've tried various things and find that VARCHAR works, but is restricted to 256 characters (TEXT is accepted but appears to have the same restriction). VARBINARY seems OK on that statement but the field is truncated to 1 character (might be my mistake here). And BLOB, LONG VARCHAR, LONG VARBINARY and variants thereof are all not accepted.

Oddly, "LONG" is accepted even though in SQL it should be "BIGINT" or similar (which is not accepted).

I want a field that will work and allows 64k or more characters in a string (ideally binary).

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to