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)?
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.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.