Hi Paul,
2003年 7月 9日 水曜日 11:17、Paul DuBois さんは書きました:
> At 12:31 +0900 7/8/03, Nils Valentin wrote:
> >Hi Koh,
> >
> >Shouldn't the value in the first sample be used like this ?
> >
> >1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
> >
> >Correct me if I am wrong.
>
> You're wron
At 12:31 +0900 7/8/03, Nils Valentin wrote:
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
You're wrong. :-)
0x6100620063006400 is a hex literal, which will be treated as
a string
, check out ExcelSQL! - see http://www.excelsql.com -
> -Original Message-
> From: Koh Swee Meng [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2003 6:07 AM
> To: [EMAIL PROTECTED]
> Subject: Re: "select * from table where field=hex" doesnt work
>
>
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 11:55、Koh Swee Meng さんは書きました:
> i inserted a new record with this SQL
> "INSERT
e Meng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 10:55 AM
Subject: "select * from table where field=hex" doesnt work
> i inserted a new record with this SQL
> "INSERT INTO table1(field1) VALUES(0x6100620063006400)"
> typ
i inserted a new record with this SQL
"INSERT INTO table1(field1) VALUES(0x6100620063006400)"
type of table1.field1 is tinyblob.
to retrieve the record, i tried SQL belows,
1) SELECT * FROM table1 WHERE field1 = 0x6100620063006400;
2) SELECT * FROM table1 WHERE field1 LIKE 0x6100620063006
