Re: NULL values in IN condition
From: Álvaro G. Vicario <alvaroNOSPAMTHANKS_at_demogracia.com>
Date: Fri, 12 Dec 2008 13:35:39 +0100
Message-ID: <ghtlql$9g9$1@huron.algomas.org>
>
> Mine would be: CHAR(1)
Date: Fri, 12 Dec 2008 13:35:39 +0100
Message-ID: <ghtlql$9g9$1@huron.algomas.org>
Thomas Kellerer escribió:
> Álvaro G. Vicario, 12.12.2008 11:34:
>> Carlos escribió: >>> Why on earth could someone define a column as varchar2(1)?? >> >> What's your suggestion to store a single character?
>
> Mine would be: CHAR(1)
*gasp*...
I had assumed that, since it didn't have the leading "2" as in VARCHAR2 it was one of those peculiar Oracle types tagged as "do not use!" like, well, VARCHAR. And something that didn't help is that SQL Developer doesn't allow such type in the "Add column" dialog.
This is what happens when you code in more DBMS than you're able to learn xD
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://bits.demogracia.com -- Mi web de humor al baño María: http://www.demogracia.com --Received on Fri Dec 12 2008 - 06:35:39 CST