German Characters

[gigamike]

Hi Guys,

Any idea, i have 2 MySQL database and on DATABASE 1, German characters works fine while on my DATABASE 2, German characters like ä ö ü was replace by chracter ?

Thanks,

Mike

[Louis11]

Could you post your database setup?

[gigamike]

Hi,

thanks for the response


Here is the table structure

German Characters works fine here

CREATE TABLE `language` (
`lang_id` bigint(10) NOT NULL auto_increment,
`language` varchar(50) NOT NULL default '',
`constant` varchar(100) NOT NULL default '',
`default` text NOT NULL,
`custom` text NOT NULL,
`set_default` char(1) NOT NULL default 'Y',
PRIMARY KEY (`lang_id`)
) TYPE=MyISAM AUTO_INCREMENT=1209 ;

PhpMyAdmin
http://www.gigamike.net/images/database1.gif


German Characters was converted to ?

CREATE TABLE `language` (
`lang_id` bigint(10) NOT NULL auto_increment,
`language` varchar(50) NOT NULL default '',
`constant` varchar(100) NOT NULL default '',
`default` text NOT NULL,
`custom` text NOT NULL,
`set_default` char(1) NOT NULL default 'Y',
PRIMARY KEY (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1209 ;

http://www.gigamike.net/images/database2.gif

Im planning tp play with the charset later maybe that's the problem...

Thanks,

Mike


Could you post your database setup?

[Ozz]

I think Charset=latin1 is the problem... I may be wrong but latin 1 does not support all european characters. You may consider UTF-8 or latin1_german1 or 2 instead of latin1_bin

[gigamike]

Thanks for the response ozz...ill try that


I think Charset=latin1 is the problem... I may be wrong but latin 1 does not support all european characters. You may consider UTF-8 or latin1_german1 or 2 instead of latin1_bin

[gigamike]

Hi,

Please help, coz i created another table with the same database, table1 works fine while table2 is not for european character and they have the same structure. Characters ä ö ü change to ?

Thanks,

Mike

I think Charset=latin1 is the problem... I may be wrong but latin 1 does not support all european characters. You may consider UTF-8
or latin1_german1 or 2 instead of latin1_bin