tags:

views:

31

answers:

1
Q: 

Issues with data types

The datatype char does not appear in the Data Architect for version 10. It now shows up as character.

I cannot find anything in the documentation for this type.

I have spent months developing a WCF Custom Adapter for the Advantage Database. Now I am getting data type exceptions because of the CHARACTER data type.

Does anyone know of any other undocumented modifcations to the MetaData?

+2  A: 

CHAR and Character are the same thing. I believe the difference you are seeing in ARC 10 vs earlier versions of ARC (I am assuming here, sorry) was a cosmetic bug fix. In ARC 9.1 for example, if you click the drop down it was listed as Character.

Using sp_getColumns stored procedure I see that the type is returned the same for both ADS 10.0 and ADS 9.1 (both are CHAR).

What sort of errors are you getting as far as data type exceptions?

Edgar  2010-10-14 23:12:54
This didn't happen in version 9. I am using sp_getProcedureColumns
Howard Edidin  2010-10-15 11:57:30
This still does not give much information, but with some more assuming I think I understand the change.in 9.x the TYPE_NAME appears to return CHAR and in 10 it now seems to return CHARACTER.So a couple of things here. A) sp_getProcedureColumns is undocumented and as a result subject to change since there is not documentation (in my opinion)B)DATA_TYPE returns the same for both (1). Maybe use this as a workaroundC)Perhaps you can call support and ask if this change was intentional. Maybe a bug?
Edgar  2010-10-15 15:16:35
it is definitely a bug and we will record these and many other issues directly with Sybase.
Howard Edidin  2010-10-15 15:30:40
IMO the documentation is useless
Howard Edidin  2010-10-15 15:31:03

related questions

How to define a current user?
Why do I get "Error 6060" when I try to use DBD::Advantage with a 64-bit perl on Linux?
Advantage Database Server: in-memory queries.
Advantage Data Architect doesn't accept 'output to', are there any other options for outputting a table to a file?
Advantage Database Server ORDER BY behaviour
Option Value Changed - ODBC Error 2169
Advantage Database Server: slow stored procedure performance.
how to load a file into a blob without loading into RAM first?
Option Value Changed - ODBC Error 2169
Advantage Extended Procedure - Create and install
Concurrent update to DBF files with Advantage Local Sever and FoxPro
Accessing Advantage Management Utility values for feedback
Advantage Database ORM Tool or Code Generator Tool
Advantage Database or SQL Server
Is there a way to use VFP SQL syntax when using ADS OLEDB for VFP?
Automate conversion of Sybase .ADT files to SQL.
Paging in Advantage Database
Sybase Advantage Database server and 64 bit VFP OLE providers
Transferring data from Advantage Database Server to SQL Server
ASP.NET with Delphi 2007 for .NET. Could not load file or assembly … The located assembly's manifest definition does not match the assembly reference
Advantage 8.1 vs 7.1
Is this a bug with Advantage Database?
wrap a 32 bit Advantage Data Provider into a COM+
Update multiple values in a single statement
Safe to use TAdsSettings object in the main thread, and AdsQuery objects in other threads?