[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] MySQL, PostgreSQL the names of the fields and case sensitive


I made a few mistakes in the code examples of scripts, but generally
all right ;)

Yes, of course, names for MySQL "correct". They must be taken as a basis.

Database, table, field and columns names in PostgreSQL are
case-independent, unless you created them with double-quotes
around their name, in which case they are case-sensitive.
Note: that PostgreSQL actively converts all non-quoted names to lower
case and so returns lower case in query results.

In MySQL, table names can be case-sensitive or not, depending on which
operating system you are using.

Therefore, if the PostgreSQL to create a table like this:

CREATE TABLE "Filename" ( "FilenameId" ..., "Name" ...);

then refer to it as

select filenameid, name from filename ...

will fail.

We should be

select "FilenameId","Name" from "Filename" ...

Therefore may be problems with backward compatibility.



-- 
with best regards

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.