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: 
The last time I worked with FoxPro was some time ago, so this might not be correct; but I think when we had this problem, we got around it by writing an empty string in the INSERT or UPDATE statement. 

Then, split your string into chucks of 250 characters or less, and UPDATE your memo field by appending them, one after another, to recreate the original string.

It's a horrible, horrible way to do things, though.
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)