UniDbType

UniDbType

Postby 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
zvib
 
Posts: 4
Joined: Fri 10 Aug 2007 09:55

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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?
zvib
 
Posts: 4
Joined: Fri 10 Aug 2007 09:55

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby zvib » Fri 10 Aug 2007 12:21

It works now, I've just forgot to change one parameter. Thanks
zvib
 
Posts: 4
Joined: Fri 10 Aug 2007 09:55

Postby Alexey » Fri 10 Aug 2007 12:43

Not at all.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect Universal