IBPhoenix Development
General Information  
  Home  
  Who Are We?  
  Contact Us  
  What is Firebird?  
  IPL License  
  Events  
Blogs  
  Paul Beach  
  Philippe Makowski  
  Dimitri Kuzmenko  
Other Languages  
  www.ibphoenix.cz  
  www.ibphoenix.fr  
Services  
  Service & Support  
  Training & Consulting  
Products  
  Developer CD  
  Deployment CD  
  IBReplicator  
  dbFile  
  IBAnalyst  
  IBFirstAid  
  IBBackupSurgeon  
  IBUndelete  
  FBScanner  
  Firebird Book  
  Firebird Goodies  
  Firebird Appliances  
Shop Online  
  IBPhoenix Shop  
Development  
  Firebird Development  
  Vulcan Development  
  General Documentation  
  Webinars  
  Function and Design  
  Other Links  
Community  
  Firebird Conference 2006  
  Firebird Conference 2005  
  Get Involved  
  Member Websites  
  Projects  
  News  
  News Archive  
  Groups, Lists, and Forums  
  Powered by Firebird  
  Users of Firebird  
  Publications  
  History  
  Web Hosting  
Downloads  
  Main Downloads  
  InterBase®  
  Contributed  
Research  
  Research Center  
  Articles  
  Examples  
  FAQs  
Search  
  Search KnowledgeBase  
  Search Web Site  
  Search Mers List  
Partners  
  Partners  
     
This Site Uses:

Relationship Between Client SQL V's Database SQL

  Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Client SQL dialect 1 Any thing Delimited by double quotes (non DDL) String constant Any thing Delimited by double quotes (non DDL) String constant Any thing Delimited by double quotes (non DDL) String constant
Any thing Delimited by double quotes (DDL) String constant Any thing Delimited by double quotes (DDL) Error Any thing Delimited by double quotes (DDL) Error
Date Time stamp Date Time stamp Date Time stamp
Date as DDL Time stamp Date as DDL Error Date as DDL Error
SQL date, Time, timestamp Ok SQL date, Time, timestamp Ok SQL date, Time, timestamp Ok
64-bit numeric ??? 64-bit numeric ??? 64-bit numeric ???


  Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Client SQL dialect 2 Any thing Delimited by double quotes (non DDL) Error Any thing Delimited by double quotes (non DDL) Error Any thing Delimited by double quotes (non DDL) Error
Any thing Delimited by double quotes (DDL) Error Any thing Delimited by double quotes (DDL) Error Any thing Delimited by double quotes (DDL) Error
Date Error Date Error Date Error
Date as DDL Error Date as DDL Error Date as DDL Error
SQL date, Time, timestamp Ok SQL date, Time, timestamp Ok SQL date, Time, timestamp Ok
64-bit numeric ??? 64-bit numeric ??? 64-bit numeric ???


  Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Client SQL dialect 3 Any thing Delimited by double quotes (non DDL) Delimited ID Any thing Delimited by double quotes Delimited ID Any thing Delimited by double quotes Delimited ID
Any thing Delimited by double quotes (DDL) Error Any thing Delimited by double quotes (DDL) Error Any thing Delimited by double quotes (DDL) Ok
Date Date Date Date Date Date
Date as DDL Error Date as DDL Error Date as DDL Date
SQL date, Time, Timestamp Ok SQL date, Time, timestamp Ok SQL date, Time, timestamp Ok
64-bit numeric ??? 64-bit numeric ??? 64-bit numeric ???