' vs ´

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

' vs ´

Post by Shendemiar »

Why does ' differ from ´ when used in sql? using ' with field names (on insert or update) gives me an error, (while if i remember correctly, both of them are usable with the values.)

Is it a mysql thing or magicquotes thing or what?

´' are not easy to google for...
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post by infolock »

To quote feyd :

"single quotes don't reference columns or tables, they are strings to mysql. Backticks (`) help mysql know what is a reference and what isn't."

just can't say it any better than that
Post Reply