MySQL Forums
Forum List  »  MySQL Workbench

Re: export as sql script
Posted by: Michael G. Zinner
Date: October 20, 2008 07:35AM

The "backtick" character has a special meaning with MySQL. Please see here: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

A general rule to stay out of trouble is not use anything else than a subset of latin1 characters for your identifiers (a-z0-9_) in the first place and avoid reserved words http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

If you stick to that you are fine. And as the internal identifiers do not need to be exposed to the end users anyway there should not be any complains from that side as well.

In Workbench you can then use all its documentation features to add documentation to your schema objects in your native language since we store everything in UTF8.


Sure, some people insist on using umlauts (ä, ü, ö) or spaces or special characters like ' or # in their identifiers. But then they should not complain in the first place.

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote


Subject
Views
Written By
Posted
9052
October 19, 2008 02:07PM
Re: export as sql script
4165
October 20, 2008 07:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.