v5:dictionary:dictionary_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dictionary:data_dictionary [2015/10/03 01:08] – [Table] mnewnham | v5:dictionary:dictionary_index [2023/06/04 11:41] (current) – ↷ Links adapted because of a move operation dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <WRAP right box> | ||
+ | [[v5: | ||
+ | </ | ||
+ | ====== The Data Dictionary ====== | ||
+ | ===== Introduction ===== | ||
+ | The Data Dictionary provides a series of functions **' | ||
+ | ===== Portable Data Types ===== | ||
+ | ADOdb provides a cross-platform method of identifying the data type of a field. These values can be used as a replacement in code that relies on the data type of field to produce a result. Each database driver contains a cross-reference table of datatypes that can accessed using the [[v5: | ||
+ | ==== Summary Of Standard Types ==== | ||
+ | ^ Type ^ Represents Field Types ^ When Using addColumnSql | ||
+ | | C | character fields that should be shown in a <input type=" | ||
+ | | C2 | Like a C field, but where possible a field that can hold multi-byte (unicode) data is created | ||
+ | | X | TeXt, large text or CLOB fields that should be shown in a < | ||
+ | | X2 | Like an X field, but where possible creates a field that can hold multi-byte (unicode) data is created | ||
+ | | XL | On systems that support it, creates a large clob field (32K). This may require additional database configuration. If the database does not support it, a standard clob field is created. | ||
+ | | B | Blobs, or Binary Large Objects. Typically images. | ||
+ | | D | Date (sometimes DateTime) field | ||
+ | | T | Timestamp field | ||
+ | | L | Logical field (boolean or bit-field). Some databases emulate logicals using I2 fields | ||
+ | | I | Integer field, This may be broken down further into I2,I4 or I8 types to represent small, | ||
+ | | N | Numeric field. Includes autoincrement, | ||
+ | | R | Serial field. Includes serial, autoincrement integers. This works for selected databases. Some databases do not signify if a field is auto-increment | ||
+ | ==== Using Data Types For Non-Portable Applications ==== | ||
+ | There are benefits to using ADOdb data types even when writing an application that is not designed to be portable. The '' | ||
+ | |||
+ | ^Data Type^Description^ | ||
+ | |-9|nvarchar| | ||
+ | |-8|nchar| | ||
+ | |1|char| | ||
+ | |12|varchar| | ||
+ | |||
+ | ===== The Meta Functions ===== | ||
+ | Metadata functions convert database specific table, column and index queries into a standardized cross-database format. | ||
+ | |||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | ===== Schema Management ===== | ||
+ | <WRAP info> | ||
+ | The userid used when establishing a database connection may need specific privileges beyond normal INSERT, | ||
+ | </ | ||
+ | ==== Executing prepared code to update the schema ==== | ||
+ | Each of the methods below return an array of data, which should be executed using the [[v5: | ||
+ | |||
+ | ==== Creating A Database ==== | ||
+ | | [[v5: | ||
+ | |||
+ | ==== Managing Tables ==== | ||
+ | |||
+ | |||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | |||
+ | ==== Managing Columns ==== | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | ==== Managing Indexes ==== | ||
+ | | [[v5: | ||
+ | | [[v5: | ||
+ | ==== Managing Database Column Comments ==== | ||
+ | |[[v5: | ||
+ | |[[v5: | ||
+ | ===== XML Driven Functions ===== | ||
+ | See the section on [[v5: |
v5/dictionary/dictionary_index.txt · Last modified: 2023/06/04 11:41 by dregad