Hi,
1) show columns from SML_SMEIS; USR_SID INTEGER(10) NO NULL SMS_SID INTEGER(10) NO PRI NULL SMS_SDATE TIMESTAMP(23) YES NULL SMS_TITLE VARCHAR(50) YES NULL SMS_MARK INTEGER(10) YES NULL SMS_BODY VARCHAR(1000) YES NULL SMS_JKBN INTEGER(10) YES NULL SMS_AUID INTEGER(10) NO NULL SMS_ADATE TIMESTAMP(23) NO NULL SMS_EUID INTEGER(10) NO NULL SMS_EDATE TIMESTAMP(23) NO NULL 2) select top 10 * from SML_SMEIS; Contents of the data is not published Displayed without any problems. 3) select SMS_SID,SMS_JKBN from SML_SMEIS where SMS_JKBN is not null Be described in part SMS_SID SMS_JKBN 27150 0 27151 0 28057 0 28058 0 28059 1970-01-01 Data does, "1970-01-01" that contains. Only one line SMS_TITLE, SMS_BODY including non-ASCII. Version1.1 from Version1.2 Do not convert to the cause? "SML_SMEIS" table will have 20,594 lines. Connect Options: LOCK_MODE=3 LOCK_TIMEOUT=5000 DEFAULT_LOCK_TIMEOUT=5000 MULTI_THREADED=0 IFEXISTS=TRUE AUTOCOMMIT=OFF DB_CLOSE_ON_EXIT=FALSE CACHE_SIZE=32768 CACHE_TYPE=SOFT_LRU MVCC=TRUE PAGE_STORE=TRUE Thanks -- HK -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
