Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feeder4.cambrium.nl!feed.tweaknews.nl!news2.euro.net!newsfeed.freenet.de!news.newsland.it!news-15.escomposlinux.org!not-for-mail From: =?ISO-8859-1?Q?=22=C1lvaro_G=2E_Vicario=22?= Newsgroups: comp.databases.oracle.misc Subject: Re: NULL values in IN condition Date: Fri, 12 Dec 2008 13:35:39 +0100 Organization: escomposlinux.org Lines: 25 Message-ID: References: <7a38043a-0ed6-4266-b0d7-c497cd0382be@t39g2000prh.googlegroups.com> <6qetjqFbtbn9U1@mid.individual.net> NNTP-Posting-Host: 51.red-80-37-14.staticip.rima-tde.net Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Trace: huron.algomas.org 1229085334 9737 80.37.14.51 (12 Dec 2008 12:35:34 GMT) X-Complaints-To: netnews@news-15.escomposlinux.org NNTP-Posting-Date: Fri, 12 Dec 2008 12:35:34 +0000 (UTC) User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) In-Reply-To: <6qetjqFbtbn9U1@mid.individual.net> Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAMAAABg3Am1AAAABGdBTUEAAK/INwWK6QAAABl0 RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAAGUExURQAAAP///6XZn90AAADwSURB VHjaxJZREsMgCAXX+1+6bZoY0IfgTDr1K4msAg8xtM3BPwDeYw9Y7vsIwBaAHSlgzCIIb65SFgFR MofPZPYjQS653iEWl6eAqlIpEKR11icTjrkw1h5+5mc7gSGPzWIj5rI74fNVB90nnc1xkiRglzbf jpOkgH4Cut25PG3OhFnxmgF1+Kyftws4Fd3a1zOi/ui+iCpBVUckNT5v5C10AJYt0rSssXy2AL8J MgaTsdEnL8D3EZmWQLuxkaWtqAhQAJqviQLQTKytBNzxtiqwF0Oh3QcNf3GhzErLGie+EXX1yltt Vee//zl5CTAA4FAHcXyuylAAAAAASUVORK5CYII= Xref: news.cambrium.nl 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 --