Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Selecting reserved word columns in SQLite More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Careful about the case! (Score:2)

by bart (450) <bart.lateur@pandora.be> on 2008.08.06 16:49 (#64233) Journal
It probably depends on what database you use... But at least in Oracle, the case of the column names is treated differently for unquoted and for quoted names.
- An unquoted column name is internally converted to upper case
- A quoted column name is case preserved
So you may have to change "order" to "ORDER" to get the same case for both quoted and unquoted column names.
Reply to This

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.