Question on Unicode/UTF8

2005-03-19 Thread Jalil Feghhi
I know this issue has been brought up many times and I have tried to search and read as much as possible but still have not been able to resolve my issue. I have a mysql database (not the latest but it supports unicode). I am keeping some columns in utf8 format and only save data that is in utf8.

Data Storage

2004-12-20 Thread Jalil Feghhi
Are there any way to configure MySQL 4.1 to use more than one drive for data files (for example, in a RAID 5 solution)? If so, could somebody point me at the right information. Regards, -JF -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Order By When Grouping

2004-12-19 Thread Jalil Feghhi
Let's say I have a table w/ three rows: ID, Time, and Name. when I do: select Time, Name group by Name Order By Time MySQL selects one of the Time fields if there are rows with the same Name and then does the ordering using this selected field (I am not sure what is the logic but it seems it

RE: Full-Text Search

2004-10-26 Thread Jalil Feghhi
Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 6:30 AM To: Jalil Feghhi Cc: [EMAIL PROTECTED] Subject: Re: Full-Text Search 1. The rows are sorted in the same order as any other query that doesn't have and order by specified, which means usually in the order they were entered

Full-Text Search

2004-10-25 Thread Jalil Feghhi
In the MySQL documentation, it says that: Boolean full-text searches have these characteristics: * They do not use the 50% threshold. * They do not automatically sort rows in order of decreasing relevance. You can see this from the preceding query result: The row with the highest