|
|
|
|
|
|
| Author |
Message |
Peter Lauri
*nix forums beginner
Joined: 25 Nov 2005
Posts: 40
|
 Posted: Wed Jul 19, 2006 5:11 am Post subject:
FULL TEXT search and Thai
|
|
|
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languages. I think this screws up the
indexing, and complete sentences are classed as a word. Assume Thai
characters:
Thisisasentenceinthai. ButIcannotsearchforsentenceinthatsearch.
I want to search for "sentence", but can not. How can this be done? And will
the indexing ever work?
Best regards,
Peter Lauri |
|
| Back to top |
|
 |
Peter Lauri
*nix forums beginner
Joined: 25 Nov 2005
Posts: 40
|
| Posted: Thu Jul 20, 2006 10:20 am Post subject:
FULL TEXT and Asian languages
|
|
|
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languages. I think this screws up the
indexing, and complete sentences are classed as a word. Assume Thai
characters:
Thisisasentenceinthai. ButIcannotsearchforsentenceinthatsearch.
I want to search for "sentence", but can not. How can this be done? And will
the indexing ever work?
Best regards,
Peter Lauri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org |
|
| Back to top |
|
|
Barry
*nix forums Guru Wannabe
Joined: 10 Jul 2005
Posts: 149
|
| Posted: Fri Jul 21, 2006 9:55 am Post subject:
Re: FULL TEXT and Asian languages
|
|
|
Peter Lauri schrieb:
| Quote: | Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other languages. I think this screws up the
indexing, and complete sentences are classed as a word. Assume Thai
characters:
Thisisasentenceinthai. ButIcannotsearchforsentenceinthatsearch.
I want to search for "sentence", but can not. How can this be done? And will
the indexing ever work?
Best regards,
Peter Lauri
well you can use: |
WHERE text LIKE '%sentence%'
is it that what you are looking for?
You can also use regular expressions.
These will also work on Asian text.
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 2:00 pm | All times are GMT
|
|
Car Loan | Mortgage | Loans | Remortgages | Singapore Shopping Guide
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
MySQL
