2 Questions: 1. Full-text Search 2. Loading 1Gb Data

2006-08-18 Thread AmirBehzad Eslami
Dear list, I'm programming a PHP-driven Search Engine for a newspaper. Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0 1GB of Text encoded by UTF-8 An average of 1Mbyte Data is inserted to database every day A common SQL-Query: SELECT COUNT(*) FROM news_archive WHERE

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

2005-11-27 Thread AmirBehzad Eslami
Mohsen wrote: But himself solved his problem. with : mysql_query(SET NAMES utf8); Even 4.0.x Wrong. I decided to prepare two different versions for my software: - A MySQL 4.0-friendly version using Romanizing method (Hats off to you, Ehsan) - A MySQL 4.1-compatible

MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

2005-11-24 Thread AmirBehzad Eslami
Dear list, I'm considering programming a simple Search Engine for a website, to find Arabic/Persian data within a MySQL database. This database contains a huge amount of data, encoded with Unicode (UTF-8). The big deal is to ** reduce the response time ** to end-users. My

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

2005-11-24 Thread AmirBehzad Eslami
On 24/11/2005, Alec worte: I think this is your problem: MySQL does not properly support Unicode until version 4.1. I am successfully using FullText with MySQL 4.1 to sort UTF-8 encoded Japanese text. I see no reason why it should not work for Arabic - if you upgrade. Dear