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!
We build. You grow.
Get best community software hereStart 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
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,
---
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
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
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
