Quote problem with TextPad.

Stephen Salbod <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
CREATE TABLE 'members' (

  `members` int(10) NOT NULL,

  `fname` char(50) NOT NULL,

  `lname` char(50) NOT NULL,

  `phone` char(50) NOT NULL,

  `email` char(50) NOT NULL

) TYPE=MyISAM;

 

 

INSERT INTO `members` VALUES (1, 'John',  'Doe',    '1234567',
'[email protected]');

INSERT INTO `members` VALUES (2, 'Jane',  'Doe',    '8373728',
'[email protected]');

INSERT INTO `members` VALUES (3, 'Steve', 'Salbod', '7449373',
'[email protected]');

INSERT INTO `members` VALUES (4, 'Santa', 'Claus',  '9999999',
'[email protected]');

----------------------------------------------------------------------------
-------------------------------------------------------------

I used the TextPad to create a file (quotes.sql) with the above contents.
When I used SOURCE to read the file into MySQL  I got an error that the
MEMBERS TABLE was not created. I notice that single quotes in the file
appeared to be different. I looked at the file in DEBUG and found that both
QUOTES on the CREATE  TABLE line were HEX 60, while the pair of QUOTES on
all of lines were HEX 27 and HEX60, respectively.  From this, can I assume
that MySQL requires both and Opening single quote (HEX 60) and a Closing
single quote (HEX 27)?  And second, is their a way to configure TextPad, so
that it produces the correct quote pairs?

 

Any suggestions will be welcomed. Thank you.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.