[#34056] indexer does not work properly in languages with different decimal notation

[chrisdavenport]

[#34056] indexer does not work properly in languages with different decimal notation

== Reproduce

Have a joomla site in a language that uses comma instead of a dot for decimal places (ex: Portuguese).

Turn on search indexer content plugin.

Edit a content item in the frontend and save.
It will appear an sql error like this

Column count doesn't match value count at row 1 SQL=INSERT INTO 29i8c_finder_tokens (term,stem,common,phrase,weight,context,language) VALUES ('a', 'a', 0, 0, 0,0667, 1, 'pt')

Note the "0,0667" it should be "0.0667" and the error is there.

[brianteeman]

(updated title)

[wilsonge]

I guess this change is needed in the other two database files as well?

[brianteeman]

Copied steps to reproduce from joomlacode

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4116.}

[roland-d]

Hello @chrisdavenport

Thank you for your contribution.

The last comment here was on 4th January 2015. So the question is, Is this issue/pull request still valid?
If no reply is received within 4 weeks we will close this issue.

Thanks for understanding!

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/4116.}

[zero-24]

Closing as this repo is removed. Here is a redo of the needed changes also for postgres and the mssql driver. Thanks @chrisdavenport

#8372