[development] Any solution for solving DB reserved word conflict?

Edison Wong hswong3i at edin.no-ip.com
Mon Feb 18 18:14:13 UTC 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
I have an indeed brain storming about using `` or [ ], too. The main 
point of choosing [ ] is about its pair up style, so the regex for 
replace will be much simpler, and similar idea as { } (not new to 
drupaler). I am not trying to trade off our MySQL users; BTW, just 
because `` is less optimal in this case, if we are asking for a suitable 
and universal escape character token ;-(

Konstantin Käfer wrote:
|> First of all, quota all potential reserved word with [ ] (since it is 
a pair up token, easy for regex), and further more replace it as DB 
specific delimited identifiers within each driver implementation.
|
| If we go that route, I suggest using `` over []. As you said, 
backticks are the MySQL quotes and since 90% of all Drupal sites use 
MySQL it seems straightforward to use that method.
|
| Konstantin

- --
Edison Wong
hswong3i at gmail.com
http://edin.no-ip.com/html/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFHucr1BPIQaq+ZRd8RAokZAJ96pcp/taKXaF1sruCkqAldE5G+IgCglWDy
GXQJVUsYgZ9ErGpNOgpzF6I=
=/Xc3
-----END PGP SIGNATURE-----

-------------- next part --------------
A non-text attachment was scrubbed...
Name: hswong3i.vcf
Type: text/x-vcard
Size: 187 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/development/attachments/20080219/4ca95a9f/attachment.vcf 


More information about the development mailing list