| View previous topic :: View next topic |
| Author |
Message |
TXM123
Newbie
Joined: 13 Mar 2012
Posts: 1
|
 Posted: Tue Mar 13, 2012 9:15 am Post subject: Are Sql queries case sensitive in Openoffice.org Base? |
 |
|
I was learning Sql using Openoffice.org Base but while writing queries if I was not using exact cases in a table name or column name, then it was showing errors. While my teacher said Sql is not case sensitive, and he also showed it Oracle and Ms-Access. So what is wrong with Openoffice.org Base?
Deleted image link - floris v, moderator |
|
| Back to top |
|
 |
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Tue Mar 13, 2012 9:38 am Post subject: |
|
|
Hello
Your teacher has right.
When your table names are surround by double quotes they are case sensitive. When they are not surround by double quotes they not case sensitive.
When the query is generated by OOo then most of the time table names are surround by double quotes and thus case sensitive.
Romke |
|
| Back to top |
|
|
dacm
Super User
Joined: 07 Jan 2010
Posts: 734
|
|
| Back to top |
|
|
|
