[Zope] Resolving nvarchar fields via ZmxODBCDA

[Júlio Dinis Silva]

>It fails under ZmxODBC
>the following example shows how to convert the nvarchar fields to char type
>fields within an SQL query so that ZmxODBC can deal with them:
>
>
>SELECT
>table_catalog = CONVERT(char(30),table_catalog),
>table_name = CONVERT(char(30),table_name),
>column_name = CONVERT(char(30),column_name),
>data_type = CONVERT(char(30),data_type)
>FROM INFORMATION_SCHEMA.COLUMNS
>where column_name like <dtml-sqlvar search_string type=string>
>order by ordinal_position
>The same technique should apply to other unsupported types.

This works ok.

But Meanwhile I've seen other problems:

-There are problems also with TimeStamp/smalldatetime, and even
a convert to char(x) still gives an InternalError.
-And if a column returns null,i.e, the field is empty, then there is also an 
InternalError(I remember this null problem was mentioned in the past by the 
author of zmxodbc).

Regards,
Júlio Dinis
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.