MS
SQL kann damit problemlos umgehen. Das trifft aber nicht auf alle Datenbanksysteme zu.
Wenn man mit Delphi Datenbankprogramme schreibt, ohne sich auf die dahinterliegende Datenbank festzulegen, sollte man halt immer im Auge behalten, dass QuotedStr funktionieren kann, aber nicht muss.
Zitat von
Access:
In
Access, you use the double-quote character around literal text, such as the Control Source of a text box: ="This text is in quotes." Often, you need quote marks inside quotes, e.g. when working with DLookup (). This article explains how.
Zitat von
MySQL:
MySQL QUOTE () produces a string which is a properly escaped data value in an
SQL statement, out of a user supplied by the string as an argument. The function achieves this by enclosing the string with single quotes, and by preceding each single quote, backslash,
ASCII NUL and control-Z with a backslash.
Zitat von
PostGres:
Basically, a single quote is used to define a token as a string; this is the context used in PostgreSQL for different purposes. When we write any text in a single quote it is treated as a reference object and the identifier is represented by using double-quoted text. For example, suppose our statement is like select ‘Welcome in PostgreSQL’;
Zitat von
SQLite:
The SQLite quote () function allows you to escape a string so that it’s suitable for inclusion in an
SQL statement. Strings are surrounded by single-quotes with escapes on interior quotes. BLOBs are encoded as hexadecimal literals. Note that strings with embedded NUL characters cannot be represented as string literals in
SQL.
Zitat von
Ingres:
Use single quotes to delimit embedded
SQL string literals. To embed a single quote in a string literal, you must double it. Example: Quote usage in string literals. exec
sql insert into comments (anecdotes) values ('single'' quote followed by double " quote'); This insert example writes the following string into the anecdotes column of the comments table: single' quote followed by double ...
Zitat von
Oracle:
Oracle Database offers the ability, in both
SQL and PL/
SQL, to specify our own user-defined delimiters for string literals. Here's how it works: you prefix your literal with the letter "q". Then you type a single quote, followeed by your starting delimiter for the literal. Then you type your literal string without having to double up on your single quote characters. When you have ...
Sie machen es alle ähnlich und doch alle ein bisserl anders, soviel zum Thema "Standardisierung"
Das Schöne an Parametern ist, dass man sich im Delphi-Quelltext nicht um diese Feinheiten kümmern muss. Da nimmt einem das die Datenbankschnittstelle ab.