Timeline for Search for Arabic text ignoring diacritics, alef hamza differences, and kashida in SQL Server and Oracle
Current License: CC BY-SA 4.0
21 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2018 at 9:17 | history | edited | user1822 | CC BY-SA 4.0 |
edited title
|
| Nov 13, 2018 at 9:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 12, 2018 at 16:21 | comment | added | swasheck | You could consider changing collations. In the past (for Greek) I've stored the exact data under Latin1_General_100_CS_AS and then had another "searchable" column with Latin1_General_100_CI_AI which ignores case and accents. Arabic_CS_AI and Arabic_CI_AI exist | |
| Oct 12, 2018 at 16:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 10, 2018 at 10:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 7, 2018 at 23:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 26, 2018 at 12:35 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 26, 2018 at 4:17 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 22, 2018 at 19:38 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| S Mar 15, 2018 at 6:43 | history | edited | Andriy M | CC BY-SA 3.0 |
spelling, grammar
|
| Mar 15, 2018 at 6:11 | answer | added | Husam Mohamed | timeline score: -1 | |
| Mar 15, 2018 at 5:58 | review | Suggested edits | |||
| S Mar 15, 2018 at 6:43 | |||||
| Feb 14, 2018 at 21:28 | history | tweeted | twitter.com/StackDBAs/status/963887648103387138 | ||
| Apr 14, 2016 at 14:10 | comment | added | Hannah Vernon♦ | well, yes, of course it would. @Paparazzi offered that as a solution to your problem, he didn't say it wouldn't take extra storage. | |
| Apr 14, 2016 at 14:03 | comment | added | Creative_0Q | @Max Vernon, thanks for clarification. I think using extra column would require extra storage. | |
| Apr 14, 2016 at 13:43 | comment | added | Hannah Vernon♦ | @Creative_Q - Paparazzi means add an additional column to store the simplified form of each word, and use that for the search function only. | |
| Apr 14, 2016 at 12:51 | comment | added | paparazzo | Oh, no - double the storage. | |
| Apr 14, 2016 at 12:42 | comment | added | Creative_0Q | thanks Paparazzi, but I'm aware of this. this has the drawback of loosing the exact words, while my situation requires that I should maintain the original text as is, in addition to the search capability. and using a search column would double the required storage | |
| Apr 14, 2016 at 12:37 | comment | added | paparazzo | In a dev environment like .NET remove the diacritics and store the value in a search column. stackoverflow.com/questions/249087/… | |
| Apr 14, 2016 at 12:01 | review | First posts | |||
| Apr 14, 2016 at 12:16 | |||||
| Apr 14, 2016 at 12:00 | history | asked | Creative_0Q | CC BY-SA 3.0 |