ñ and cuotes: á,ó,ú,í,é and cigilla (portuguess)

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
User avatar
visonardo
Forum Contributor
Posts: 136
Joined: Mon Oct 02, 2006 7:49 pm
Location: Argentina, South America´s Sun.

ñ and cuotes: á,ó,ú,í,é and cigilla (portuguess)

Post by visonardo »

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]


I have my structure db backup thus [syntax="sql"]DROP TABLE IF EXISTS `categorias`;
CREATE TABLE IF NOT EXISTS `categorias` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_nombre` varchar(40) NOT NULL default '',
  `cat_viene` int(11) NOT NULL default '0',
  `cat_nivel` int(2) NOT NULL default '1',
  `cat_orden` int(2) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4249 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4249 ;

When it is created, all good, but when continue inserting the data backup, the ó, á and more and ñ are replaced by "?" question character. But when i run online the aplication that use this db and insert a text with this special chars, this data is shown correctly, but data that was insert by the backup no. How can i fix that?


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
visonardo
Forum Contributor
Posts: 136
Joined: Mon Oct 02, 2006 7:49 pm
Location: Argentina, South America´s Sun.

Post by visonardo »

ok feyd, thank. Be the way, the problem that i had has been fixed. I needed select "latin1" in file´s charset in phpmyadmin when i upload the backup. Hope it solve that to others too.
Post Reply