1. utf8mb4 varchar? I can't see it...
2. "españa" was entered manually:
Search found 9 matches
- Sun Oct 08, 2023 9:13 pm
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
- Sun Oct 08, 2023 12:33 pm
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
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...
- Thu Oct 05, 2023 4:58 pm
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
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...
- Thu Sep 28, 2023 11:59 am
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
Re: unicode indexing
Sending PM failed. "Internal Server Error"
- Wed Sep 27, 2023 11:23 am
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
Re: unicode indexing
I created a dummy file with
containing Unicode characters, but after indexing the search returns only latin
Does it mean that I cannot override the server-set headers?
Code: Select all
<?php header('Content-Type: text/html; charset=utf-8'); ?>
<!doctype html>
Does it mean that I cannot override the server-set headers?
- Mon Sep 25, 2023 10:59 am
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
Re: unicode indexing
Sorry for delay.
The Unicode characters are still missing in DB.
The Unicode characters are still missing in DB.
- Sat Sep 09, 2023 12:21 pm
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
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 | |...
- Fri Sep 08, 2023 5:00 pm
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
Re: unicode indexing
Hi, thank you for your answer.
Is that correct?
Is that correct?
- Fri Sep 08, 2023 11:35 am
- Forum: Sphider Help
- Topic: unicode indexing
- Replies: 18
- Views: 12391
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?