We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

I get '?' mark instead of 'ő' and 'ű' characters (Hungarian) | Forum

Higen
Higen Jan 19 '12
Hello Everybody!

I have got some problem with the Hungarian characters.
Őő, Űű

[Oxwall 1.2.6]

I realized it in the Links, in the Label field.

időszakonként = id?szakonként
működtetünk =  m?ködtetünk
ismeretterjesztő előadásokat = ismeretterjeszt? el?adásokat

I need help. Where should I made the changes: in the Administration interface or in the program code or in the sql??

-----------------
Sziasztok!

A Magyar ékezetekkel problémám van. Az Őő és Űű betűkkel. Ha valaki tud rá megoldást, akkor kérem szóljon!

Az ékezetek helyett kérdőjelek jelennek meg!



The Forum post is edited by Higen Jan 19 '12
Higen
Higen Jan 19 '12
The Links_link table charset was Latin1.

---

Here is the solution: 

Create a backup. Delete links_link table and run a sql command:


CREATE TABLE IF NOT EXISTS `ow_links_link` (
  `id` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL,
  `url` mediumtext NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `timestamp` int(11) NOT NULL,
  `privacy` varchar(50) NOT NULL default 'everybody',
  PRIMARY KEY  (`id`),
  KEY `userId` (`userId`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf-8 AUTO_INCREMENT=8 ;


INSERT INTO `ow_links_link` (`id`, `userId`, `url`, `title`, `description`, `timestamp`, `privacy`) VALUES
(1, 3, 
The Forum post is edited by Higen Jan 19 '12
Higen
Higen Jan 19 '12
Attention!

ow_base_scheme [default charset is good, but some fields charset are latin1]

Change to utf8

rightCssClass     varchar(50)     utf8_general_ci
leftCssClass     varchar(50)     utf8_general_ci
cssClass     varchar(50)     utf8_general_ci


Or backup, delete sql command...

CREATE TABLE IF NOT EXISTS `ow_base_scheme` (
  `id` tinyint(4) NOT NULL auto_increment,
  `rightCssClass` varchar(50) default NULL,
  `leftCssClass` varchar(50) default NULL,
  `cssClass` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--

ow_blogs_post [default charset is latin1, but some fields charset are utf-8]  ??!?

Backup, delete, sql command...

CREATE TABLE IF NOT EXISTS `ow_blogs_post` (
  `id` int(11) NOT NULL auto_increment,
  `authorId` int(11) NOT NULL,
  `title` varchar(512) NOT NULL default '',
  `post` text NOT NULL,
  `timestamp` int(11) NOT NULL,
  `isDraft` tinyint(1) NOT NULL,
  `privacy` varchar(50) NOT NULL default 'everybody',
  PRIMARY KEY  (`id`),
  KEY `authorId` (`authorId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2



The Forum post is edited by Higen Jan 19 '12
Michael I.
Michael I. Jan 20 '12
Thanks for sharing a useful information.