Re: Inserting control characters in SQL

2011-03-17 Thread John English
On 14/03/2011 09:26, Bruce Wen wrote: If indeed necessary to insert one control character, you need insert the int value (ASCII code) of the control character, I think. Of course, the column's data type should be int or tinyint. No, it's a control character embedded in a string. I've ended up

Re: Inserting control characters in SQL

2011-03-17 Thread Bruce Wen
To convert an int to a char, just use the following statement: char c = (char) 134; You can cast integer to char directly. Is this what you need? -Original Message- From: John English john.fore...@gmail.com To: derby-user@db.apache.org Sent: Thu, Mar 17, 2011 6:00 pm Subject:

Re: track the table changes in one transaction

2011-03-17 Thread 鲍少明
I have checked the system tables derby using. I don't find any information table to track the modify time of the tables. So does it mean I need to write some code to manually track it. And if it's roll-backed, I need to clean it up? 2011/3/14 鲍少明 ioker...@gmail.com Hello group, Is there any

Re: track the table changes in one transaction

2011-03-17 Thread Myrna van Lunteren
2011/3/17 鲍少明 ioker...@gmail.com: I have checked the system tables derby using. I don't find any information table to track the modify time of the tables. So does it mean I need to write some code to manually track it. And if it's roll-backed, I need to clean it up? 2011/3/14 鲍少明