[imp] Re: imp 2.3.7cvs (20010914) and OCI8 weirdness

[Liam Hoekenga]

> > I had to change to change all of the table and field references in
> > horde/lib/Prefs/sql.php to upper case.
>
> Does someone have a moment to see if MySQL and other engines return column
> names in upper case if you create them in upper case? That would be an ugly
> fallback solution if aliasing the column names doesn't work.
>
> -chuck

mysql> create table BLAH( BLAH varchar(10) );
Query OK, 0 rows affected (0.05 sec)

mysql> describe BLAH;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| BLAH  | varchar(10) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> show tables;
+---------------------+
| Tables_in_horde     |
+---------------------+
| BLAH                |
| horde_perms         |
| horde_prefs         |
| kronolith_event_seq |
| kronolith_events    |
| turba_objects       |
+---------------------+
6 rows in set (0.00 sec)

mysql>

Liam