SQLite3 驱动支持的SQL列类型
来源:互联网 发布:blk黑水 淘宝 编辑:程序博客网 时间:2024/06/05 18:35
SQLite驱动支持的SQL列类型
http://libdbi-drivers.sourceforge.net/docs/dbd_sqlite3/x123.html
4.1. SQLite3 (mis)features
As the SQLite3 package is constantly being improved, you should refer to the original documentation about the SQL features it supports and about the SQL features it doesn't support.
One noticeable difference between SQLite3 and other SQL database engines is that the former uses something called "manifest typing". The practical difference to the typeless nature of SQLite 2.x is negligible as it still does not support the rich typing used by most other SQL database engines. In order to satisfy the needs of the strongly typed retrieval functions of libdbi, the only way out is to declare the column types in a CREATE TABLE statement just as you would with any other SQL database engine. As an example, the following statement is perfectly fine with SQLite3, but not with the sqlite3 driver:
CREATE TABLE foo (a,b,c)
However, the following statement is fine with SQLite3, the sqlite3 driver, and just about any other SQL database engine out there:
CREATE TABLE foo (a INTEGER,b TEXT,c VARCHAR(64))
The following table lists the column types which are positively recognized by the sqlite driver. Essentially all column types supported by MySQL and PostgreSQL are supported by this driver as well, making it reasonably easy to write portable SQL code. All other column types are treated as strings.
Table 4-1. SQL column types supported by the sqlite driver
Another difference is the lack of access control on the database engine level. Most SQL database servers implement some mechanisms to restrict who is allowed to fiddle with the databases and who is not. As SQLite3 uses regular files to store its databases, all available access control is on the filesystem level. There is no SQL interface to this kind of access control, but chmod and chown are your friends.
- SQLite3 驱动支持的SQL列类型
- SQL取得列的类型
- MySQL支持大量的列类型
- dhtmlxgrid所支持的列类型
- sqlite3支持自增和缺省值列
- SQLite3支持的数据类型
- Sqlite3支持的数据类型
- sqlite3支持的数据类型
- sqlite3支持的数据类型
- sqlite3支持的文件类型
- sqlite3的时间类型
- java.sql.SQLException: 无效的列类型
- java.sql.SQLException: 无效的列类型
- java.sql.SQLException: 无效的列类型
- sql 修改列类型
- eXtremeDB 支持的 SQL 字段类型
- sqlite3 支持的关联查询
- SQL 新增列、删除列、改变列类型、添加列默认值、删除列默认值和获取列默认值的方法
- NTFS
- XSLT转换XML实例
- updateprogress改进用法
- 【从黑盒到灰盒】如何测试概率?
- oracle积累2
- SQLite3 驱动支持的SQL列类型
- 40种网页常用小技巧(JavaScript)
- 过滤驱动开发笔记(2)
- 为什么在CSDN群里说了句楼上发的图什么意思,不到十分钟..就被踢出来了????
- 源于网络 MSDN 翻译 VC++内联汇编
- 递归函数最终会结束
- updateprogress用法技巧
- java socket编程
- PHP安装问题:编译安装php5.2.0时出错解决方案