Otdfbt

My coworkers think I had a long honeymoon. Actually I was diagnosed with cancer. How do I talk about it?

Russian equivalents of "no love lost"

How to officially communicate to a non-responsive colleague?

What's the largest optical telescope mirror ever put in space?

What is the actual quality of machine translations?

How does an ordinary object become radioactive?

Which comes first? Multiple Imputation, Splitting into train/test, or Standardization/Normalization

Comparing and find out which feature has highest shape area in QGIS?

Can a user sell my software (MIT license) without modification?

Soft question: Examples where lack of mathematical rigour cause security breaches?

Find the Factorial From the Given Prime Relationship

Interview not reimboursed if offer is made but not accepted

"You've got another thing coming" - translation into French

What could have caused a rear derailleur to end up in the back wheel suddenly?

What is the giant octopus in the torture chamber for?

Words that signal future content

How to retract an idea already pitched to an employer?

Is using haveibeenpwned to validate password strength rational?

What's the name of this light airplane?

What makes Ada the language of choice for the ISS's safety-critical systems?

Was the Tamarian language in "Darmok" inspired by Jack Vance's "The Asutra"?

Is it a problem if <h4>, <h5> and <h6> are smaller than regular text?

Preventing Employees from either switching to Competitors or Opening Their Own Business

How Can I Tell The Difference Between Unmarked Sugar and Stevia?

MySQL FullText Weird Characters

MySQL hangs and table inaccessible after adding fulltext indexEscaping a question mark on the MySQL CLIWhy is this MySQL FULLTEXT query returning 0 rows when matching rows are present?Explaining the MySQL IndexingMySQL and cardinality of indexShould I increase MySQL cache?Mysql change ft_max_word_len bugTime of MySQL database removalLowering MySQL Full Text Word LengthIs it possible to safely edit mysql-bin.index file while mysql server is running

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

It appears MySQL FullText index does not index the word 'C#'. Probably because the character '#' is removed and you are left with C, which is too short to index.

My question is, how would I go about indexing 'C#' so that it is searchable in my FullText index?

Thanks,

John

mysql

share|improve this question

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

add a comment | 

1

It appears MySQL FullText index does not index the word 'C#'. Probably because the character '#' is removed and you are left with C, which is too short to index.

My question is, how would I go about indexing 'C#' so that it is searchable in my FullText index?

Thanks,

John

mysql

share|improve this question

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

add a comment | 

It appears MySQL FullText index does not index the word 'C#'. Probably because the character '#' is removed and you are left with C, which is too short to index.

My question is, how would I go about indexing 'C#' so that it is searchable in my FullText index?

Thanks,

John

mysql

share|improve this question

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

share|improve this question

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

share|improve this question

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

edited May 21 at 13:48

yagmoth555♦

12.7k31842

edited May 21 at 13:48

yagmoth555♦

12.7k31842

asked May 14 '10 at 22:24

postalservice14postalservice14

61

asked May 14 '10 at 22:24

postalservice14postalservice14

61

3 Answers
3

active

oldest

votes

0

I think this can be solved tuning the ft_min_word_len system variable, which is used to set the minimum length of words to be indexed. Set this value to two. More info here.

share|improve this answer

edited May 14 '10 at 23:43

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the reply. However, I don't think setting the minimum length to 1 is a good idea. I don't want to index 'C'. I want to index 'C#'.
  
  – postalservice14
  May 17 '10 at 15:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  set ft_min_word_len to 2 :)
  
  – Marco Ramos
  May 17 '10 at 17:17
  

  
  
  
  

add a comment | 

0

I don't know of a way to do this, and searching around it seems to be accepted as a limitation of fulltext search in MySQL.

I guess you already considered this, but just in case: you can encode non-searchable characters before storing the data in your database. So C# would become C.Sharp, C++ would become C.Plus.Plus, etc.

share|improve this answer

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

add a comment | 

0

You can upgrade ft_min_word to allow 2 characters, by default this is set to 4 characters, which to most people is a little to much, 3 would be more suitable. I have mine set to 2.

Also amongst the configuration files of MySQL full-text, you can alter a list of ignored words. I have yet been in the myself but you may find # as one of the ignored words/symbols...

share|improve this answer

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f142061%2fmysql-fulltext-weird-characters%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I think this can be solved tuning the ft_min_word_len system variable, which is used to set the minimum length of words to be indexed. Set this value to two. More info here.

share|improve this answer

edited May 14 '10 at 23:43

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the reply. However, I don't think setting the minimum length to 1 is a good idea. I don't want to index 'C'. I want to index 'C#'.
  
  – postalservice14
  May 17 '10 at 15:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  set ft_min_word_len to 2 :)
  
  – Marco Ramos
  May 17 '10 at 17:17
  

  
  
  
  

add a comment | 

0

I think this can be solved tuning the ft_min_word_len system variable, which is used to set the minimum length of words to be indexed. Set this value to two. More info here.

share|improve this answer

edited May 14 '10 at 23:43

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for the reply. However, I don't think setting the minimum length to 1 is a good idea. I don't want to index 'C'. I want to index 'C#'.
  
  – postalservice14
  May 17 '10 at 15:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  set ft_min_word_len to 2 :)
  
  – Marco Ramos
  May 17 '10 at 17:17
  

  
  
  
  

add a comment | 

I think this can be solved tuning the ft_min_word_len system variable, which is used to set the minimum length of words to be indexed. Set this value to two. More info here.

share|improve this answer

edited May 14 '10 at 23:43

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

share|improve this answer

edited May 14 '10 at 23:43

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

answered May 14 '10 at 22:49

Marco RamosMarco Ramos

2,5751824

0

I don't know of a way to do this, and searching around it seems to be accepted as a limitation of fulltext search in MySQL.

I guess you already considered this, but just in case: you can encode non-searchable characters before storing the data in your database. So C# would become C.Sharp, C++ would become C.Plus.Plus, etc.

share|improve this answer

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

add a comment | 

0

I don't know of a way to do this, and searching around it seems to be accepted as a limitation of fulltext search in MySQL.

I guess you already considered this, but just in case: you can encode non-searchable characters before storing the data in your database. So C# would become C.Sharp, C++ would become C.Plus.Plus, etc.

share|improve this answer

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

add a comment | 

I don't know of a way to do this, and searching around it seems to be accepted as a limitation of fulltext search in MySQL.

I guess you already considered this, but just in case: you can encode non-searchable characters before storing the data in your database. So C# would become C.Sharp, C++ would become C.Plus.Plus, etc.

share|improve this answer

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

share|improve this answer

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

answered May 24 '11 at 19:04

Eduardo IvanecEduardo Ivanec

12.1k13139

0

You can upgrade ft_min_word to allow 2 characters, by default this is set to 4 characters, which to most people is a little to much, 3 would be more suitable. I have mine set to 2.

Also amongst the configuration files of MySQL full-text, you can alter a list of ignored words. I have yet been in the myself but you may find # as one of the ignored words/symbols...

share|improve this answer

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

add a comment | 

0

You can upgrade ft_min_word to allow 2 characters, by default this is set to 4 characters, which to most people is a little to much, 3 would be more suitable. I have mine set to 2.

Also amongst the configuration files of MySQL full-text, you can alter a list of ignored words. I have yet been in the myself but you may find # as one of the ignored words/symbols...

share|improve this answer

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

add a comment | 

You can upgrade ft_min_word to allow 2 characters, by default this is set to 4 characters, which to most people is a little to much, 3 would be more suitable. I have mine set to 2.

Also amongst the configuration files of MySQL full-text, you can alter a list of ignored words. I have yet been in the myself but you may find # as one of the ignored words/symbols...

share|improve this answer

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

share|improve this answer

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315

answered Oct 15 '11 at 16:27

PaparazzoKidPaparazzoKid

226315