MaxLength and dates 
Author Message
 MaxLength and dates

Hi!

I need to know some data of these databases:
Oracle, Sybase, DB2, Informix, SqlServer.

 -> MaxLength of Table name:

 -> MaxLength of Column name:

 -> MaxLength of Alias name (t1.id AS userId):

 -> how i can specify:
      select * from t where date='2001-02-10';
    but not afected by locale.
     (in Oracle I use:
      select * from t where date=to_date('2001/02/10','YYYY/MM/DD');
      I prefer specify the format rather than rely in an standard
     )

 -> how i can specify:
      select * from t where name='cote d'or';
    but not afected by locale (i dont know if locale is aplicable for that).
    (in Oracle I use:
     select * from t where name='cote d'||chr(39)||'or';
    )

thanks

javi.

pd.- please specify in your reply what database you are you talking about
;-)



Sat, 20 Mar 2004 16:38:31 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. MaxLength and dates

2. MaxLength and dates

3. MaxLength and dates

4. MaxLength and dates

5. Maxlength property not working properly

6. COL_LENGTH and MaxLength

7. Maxlength on the statement in ODBC.

8. maxlength of parameter?

9. MaxLength in DBGRID ?

10. FIX for TDBEdit Maxlength feature?

11. DBEdit.MaxLength and numbers

12. Delphi 1 and 2 Tdbedit.MaxLength property


 
Powered by phpBB® Forum Software