SQL Mode ANSI_QUOTES

Posted June 24th, 2008 by sheeri

I was asked today about the ANSI_QUOTES SQL mode.

According to http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html, ANSI_QUOTES mode changes the functionality of double quotes (") to be like the backtick (`). Normally the functionality of double quotes is more like that of single quotes (').

You might use this when you have a table with ...

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Comment: *

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
Lines and paragraphs break automatically.
You may use <swf file="song.mp3"> to display Flash files inline
Avast! This website be taken over by pirates on September 19th. Yarr!
Each email address will be obfuscated in a human readable fashion and replaced with a spamproof clickable link, without loosing the mailto URL scheme semantics and operations.
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

Email me about all replies to this article.

Captcha

This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Math Question: * 1 + 17 =

Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.