Question: I am using PHP to enter data in a visual Foxpro 9 database.

My problem is that the ODBC driver is imposing a limit of 255 characters on memo fields.

I tried using the following to get round the problem:

```
$sSQL = 'Insert Into detail (IT_DOC,IT_MEMO) values (?,?)';

$stmt = odbc_prepare($conn, $sSQL);
$res = odbc_execute($stmt, array($head['IT_DOC'] , $text));

```

However, this gives me the error: 

```
Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC Driver Manager] 
Driver does not support this function, SQL state IM001 in SQLDescribeParameter in C:\inetpub\wwwroot\import.php on line 149

```

Any help in solving this would be much appreciated.

Answer: 
Oohhh... those who hate FoxPro... However, I've made a VERY DESCENT living with it since 1987, still use it today in addition to other development languages and still working SQL. Back in the day, it was one of the greatest / fastest databases that didn't require high-priced DBAs, and completely self-contained database and GUI. 

I wouldn't use the ODBC driver, but get the latest OleDB driver from Microsoft... you might have better luck...
You need to use the OLE DB driver. 

This might help: [can't connect via OleDB to foxpro \*.dbc when in network folder](http://www.webdeveloper.com/forum/showthread.php?t=208433)