Forum Freeglobes

spanish · 12-10-2009 02:12:10

Hello,

Apache 2
PHP 5.2.1
MySQL 5.0.44
FreeGlobes 03.01.2009-RC2 (Spanish translated)
Database type and collating: MyISAM utf8_general_ci
config.php: $CONFIG['encoding'] = "ISO-8859-1";
Charset metatag of template: <meta http-equiv="Content-Type" content="text/html; charset=<{$CONFIG.encoding}>" />

I have problems with search and spanish non ASCII characters (ñ, á, é, í, ó, ú,...).

1.- If I submit a link that contains "diseño" in the description, the link is added to database and "diseño" is added like "diseño" in database but appears like "diseño" in the web site.

2.- If I search "diseño" in the web site, I don't have results. If I search "diseño", I have the result.

If I change ISO-8859-I to UTF-8 in config.php encoding, I have the same problem.

I need change the collating of database? Other solution?

Thanks,

Manuel

Uniktrue · 12-10-2009 07:47:36

Hello,
Have you this in your include/recherche.php :

Code:

if (!empty($seek))
{
    if(isUTF8($seek)) {
        $seek = utf8_decode($seek);
    }
    $seek = strip_tags($seek);
    
    $km =& get_manager("keyword");
    $lm =& get_manager("link");
    $myts =& MyTextSanitizer::getInstance();
    $re = MyRewriteEngine::getInstance();

?

spanish · 19-10-2009 08:22:33

Hello Uniktrue,

Yes, I have this code in recherche.php (lines 12-22).

Do I need to change anything?

Thanks and greetings,

Manuel

Uniktrue · 19-10-2009 11:59:45

delete this lines :

if(isUTF8($seek)) {
$seek = utf8_decode($seek);
}

and test

spanish · 20-10-2009 04:22:39

Thanks, Uniktrue,

I have deleted that line, but the problem continues.

Cordial greetings,

Manuel

spanish · 21-10-2009 06:25:35

Hello again,

I have located where is the problem: only in admin area.

If I submit a new site from the public area (Basic or Premium), no problem. All is correct (including searches with non ASCII characters).

But when I edit a site or submit a new site from the admin area, characters are stored incorrectly and the searches do not work OK.

Any idea?

Thanks,

Manuel

PS: yes, I'm analyzing those files...

spanish · 22-10-2009 01:15:31

Hello,

We have installed FG into a latin1_general_ci MySQL database, and we have the same problem.

We continued doing tests and we have determined a little more where is the problem:

Table: link
Field: description
Directory: admin

That is, we only have problems with the field "description" when we submit or edit a link from admin area. In these cases, characters non ASCII of the field "description" are converted (ñ => ñ) (á => á) (etc.) and search does not find original non ASCII characters.

Example: link with name=España and description=Españoles.

1.- If we submit our link sample from public area (basic or premium), no problem. All is OK, both on the web and into database.

2.- But if we submit or edit our link sample from admin area:

2.1.- Field "name" is OK (=España, both on the web and into database) and search find it.

2.2.- Field "description" is converted (on the web = Españoles, into database = Españoles), and search don't find it.

In this case (2),

a) If we search "España", we find results (because "España" is into the field "name" -no converted-).

b) If we search "Españoles", we don't find results (because "Españoles" is into the field "description" -converted-).

c) If we search "Españoles", we find results (because "Españoles" was converted to "Españoles" into database). But no one search ñ...

Any idea?

Thanks and cordial greetings,

Manuel

spanish · 22-10-2009 11:50:46

Hello again,

The problem is FCKeditor. This WYSIWYG converts the non ASCII characters.

Interim patch:
Line 107 of /themes/admin/admin_link_siteform.html
Delete:
<{$FCKeditor}>
Add:
<textarea name="description" cols="50" rows="20"><{$description}></textarea>

Now, we don't have a WYSIWYG into admin area, but we can submit and edit links without character conversion. And we can search and find words with non ASCII characters.

\ ;-)

--------------------------------------

Any ideas about FCKeditor definitive solution?

Thanks and cordial greetings,

Manuel

Forum Freeglobes

Annonce

#1 12-10-2009 02:12:10

Problem with search and non ASCII characters

#2 12-10-2009 07:47:36

Re: Problem with search and non ASCII characters

Code:

#3 19-10-2009 08:22:33

Re: Problem with search and non ASCII characters

#4 19-10-2009 11:59:45

Re: Problem with search and non ASCII characters

#5 20-10-2009 04:22:39

Re: Problem with search and non ASCII characters

#6 21-10-2009 06:25:35

Re: Problem with search and non ASCII characters

#7 22-10-2009 01:15:31

Re: Problem with search and non ASCII characters

#8 22-10-2009 11:50:46

Re: Problem with search and non ASCII characters

Pied de page des forums