UniDbType

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
zvib
Posts: 4
Joined: Fri 10 Aug 2007 09:55

UniDbType

Post by zvib » Fri 10 Aug 2007 10:04

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 10 Aug 2007 10:41

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.

zvib
Posts: 4
Joined: Fri 10 Aug 2007 09:55

Post by zvib » Fri 10 Aug 2007 11:24

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?

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 10 Aug 2007 11:52

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.

zvib
Posts: 4
Joined: Fri 10 Aug 2007 09:55

Post by zvib » Fri 10 Aug 2007 12:21

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 10 Aug 2007 12:43

Not at all.

Post Reply