Devart Forums

Hello, I would like to find the size of each elements in UniDbType enum.
How many characters are allowed in VarChar, NVarChar objects and what are the objects Clob, Blob and Guid?

Thank you

Each server has its own size limits. We haven't implemented obtaining the type system information. Use minimal size for all the types.

• Clob is Character LOB data type. Represented as CLOB in Oracle, TEXT in SQL Server, MySQL and PostgreSQL. May be represented as UniBlob class or string in the .NET Framework.
• Blob is Binary LOB data type. Represented as IMAGE in SQL Server, BLOB in Oracle and MySQL, BYTEA in PostgreSQL. May be represented as UniBlob class or an array of bytes in the .NET Framework.
• Guid is GUID-like data type. Represented as VARCHAR in Oracle, MySQL and PostgreSQL. In SQL Client this is UNIQUEIDENTIFIER. Corresponds to Guid in the .NET Framework.

For more information please see UniDirect .NET help documentation.

Thank you, but I still have a problem. I would like to store a text which has over 10000 characters. I use Clob, it works with SQL Server but not with MS Access. I get an Exception "Failed to convert parameter value from a String to a Byte[]."

Any clue?

Please send me a small test project to reproduce the problem.
Include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.

It works now, I've just forgot to change one parameter. Thanks

Not at all.