'DEFAULT CHARSET=latin1

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
galinha
Forum Newbie
Posts: 5
Joined: Thu Jan 25, 2007 3:55 am

'DEFAULT CHARSET=latin1

Post 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]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

DEFAULT CHARACTER SET
galinha
Forum Newbie
Posts: 5
Joined: Thu Jan 25, 2007 3:55 am

Post by galinha »

How do i solve this ?

Thnks a lot ?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I just told you.
Post Reply