Vlad,

>> While the application *can* get N by querying the charset system table,
>
> Why application ? It is job of data access layer\components.
>
>> it is a rather complicated task
>
> Really ???
>
>> and also not very intuitive that it is required.
>
> Do you consider "too complex and not very intuitive" for data access
> layer
> to query system tables for fileds CHECK constraints, DEFAULT values, etc ?

This has nothing to do with fetching data. Having to query the
system tables in order to properly process the data as provided
by the client side API, does that sound "OK" to you?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com