ñ and cuotes: á,ó,ú,í,é and cigilla (portuguess)
Posted: Thu Mar 15, 2007 1:37 pm
feyd | Please use
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]
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]