Hi all,

I just started using Pervasive SQL with Clarion 5.5, but i got some errors, when the application tries to create a table who contains a string(1000) field, returns me the following error: "Maximum column length exceeded".

Now, when i try to export from Pervasive to Clarion this table using LongVarChar for the string(1000) field, Clarion don't recognize this data type.

What data type can i use for big strings(1000 or more chars)?

Thanks for your help.

Saludos.
Rafael Sotelo
SCSI S.A. de C.V.
Tel. 616-25-27
www.solucionesyconsultoria.com

Pervasive.SQL has a limit of 255 characters in fixed length string fields. To create anything longer, you'll need to use LongVarChar. If Clarion can't recognize the LongVarChar, you'll need to go back to Clarion to get them to fix it.