Page 1 of 1

'DEFAULT CHARSET=latin1

Posted: Thu Jan 25, 2007 9:50 am
by galinha
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


Hello : 

Im having this problem :

Comando SQL: 

[syntax="sql"]--
-- Table structure for table `lusex-pom`.`departments`
--
CREATE TABLE `departments` (

`ID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`code` varchar( 50 ) default NULL ,
`name` varchar( 50 ) default NULL ,
`site` bigint( 20 ) default NULL ,
`budget` decimal( 19, 2 ) default NULL ,
`spent` decimal( 10, 2 ) default NULL ,
PRIMARY KEY ( `ID` ) 
) ENGINE = MYISAM DEFAULT CHARSET = latin1 
Mensagens do MySQL :

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 13


Can I have you help ?

Thnks a Lot

Luis,


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Thu Jan 25, 2007 9:59 am
by feyd
DEFAULT CHARACTER SET

Posted: Thu Jan 25, 2007 10:04 am
by galinha
How do i solve this ?

Thnks a lot ?

Posted: Thu Jan 25, 2007 10:05 am
by feyd
I just told you.