Search found 9 matches

by denver
Sun Oct 08, 2023 9:13 pm
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

1. utf8mb4 varchar? I can't see it...

Image

2. "españa" was entered manually:

Image
by denver
Sun Oct 08, 2023 12:33 pm
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

I followed the steps as above. No changes ( mysql> select keyword from keywords where keyword like 'esp%'; +---------+ | keyword | +---------+ | espaa | +---------+ 1 row in set (0,00 sec) 1. "Query OK, 0 rows affected" was a response to each query. Is that OK? 2. In phpMyAdmin I can manua...
by denver
Thu Oct 05, 2023 4:58 pm
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

Sorry for delay again ) | links | CREATE TABLE `links` ( `link_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) DEFAULT NULL, `url` varchar(255) NOT NULL, `title` varchar(200) DEFAULT NULL, `description` text, `fulltxt` longtext, `indexdate` date DEFAULT NULL, `size` float DEFAULT NULL, `md5su...
by denver
Thu Sep 28, 2023 11:59 am
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

Sending PM failed. "Internal Server Error"
by denver
Wed Sep 27, 2023 11:23 am
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

I created a dummy file with

Code: Select all

<?php header('Content-Type: text/html; charset=utf-8'); ?>
<!doctype html>
containing Unicode characters, but after indexing the search returns only latin :(

Does it mean that I cannot override the server-set headers?
by denver
Mon Sep 25, 2023 10:59 am
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

Sorry for delay.
Image

The Unicode characters are still missing in DB.
by denver
Sat Sep 09, 2023 12:21 pm
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

OK, I have identified the problem in MySQL server settings: show variables like 'char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | |...
by denver
Fri Sep 08, 2023 5:00 pm
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

Re: unicode indexing

Hi, thank you for your answer.

Is that correct?
Image
by denver
Fri Sep 08, 2023 11:35 am
Forum: Sphider Help
Topic: unicode indexing
Replies: 18
Views: 12269

unicode indexing

I have installed Sphider 5.3.0. Everything if fine, but the search does not return the words in non-Latin characters. What's the problem?