H.Merijn Brand wrote:
Anyway to make this work *portable* ? e.g. Unify normalizes everything to as it was entered :) in Oracle all other operations work quite ok when using lower case table/column names: select, drop, create, ...
The behavior for identifiers (quoted or not) is described by SQL_IDENTIFIER_CASE and SQL_QUOTED_IDENTIFIER_CASE: <http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetinfo.asp?frame=no> <http://msdn.microsoft.com/library/en-us/odbc/htm/odbcidentifier_case.asp?frame=no> If 'Unify normalizes everything to as it was entered', then get_info() should return SQL_IC_SENSITIVE or SQL_IC_MIXED. Steffen