Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > https://www.sqlite.org/src/artifact?ci=trunkfilename=ext/icu/README.txt; However the example described here is a little bit simplistic: lower('I', 'en_us') -> 'i' lower('I', 'tr_tr') -> 'ı' (small dotless i) You depend on the encoding of the text editor,

Re: [sqlite] UPPER function depends on Locale?

On 10 Apr 2018, at 7:44am, Dr. Mucibirahman İLBUĞA wrote: > I my opinion, there should be well documented, step by step information about > how to add ICU support in SQLite. I think that the reason this doesn't exist is that different people want to use different

Re: [sqlite] UPPER function depends on Locale?

10.04.2018 10:30 tarihinde sandu yazdı: As Simon Slavin wrote, maybe in your case would be much easier to have dedicated lower/upper functions instead of recompiling with ICU option, if this is two complex for you. Hi, Yes. You and Simon are right. But in this case there is not any step by

Re: [sqlite] UPPER function depends on Locale?

Dr. Mucibirahman İLBUĞA wrote > And I really shocked that am I first person on over the world who wants to > use SQLite in their own language?... :) You are not the first person that uses SQLite with a different character set than ASCII and with a different locale other than English US. If you

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 23:18 tarihinde sandu yazdı: The example you found is not applicable in your case, because it is describing an way to develop your own functions in PHP, which is not the case for you. Dear Buraga SANDU, Thanks alot for your kind interest. I my opinion, there should be well

Re: [sqlite] UPPER function depends on Locale?

The example you found is not applicable in your case, because it is describing an way to develop your own functions in PHP, which is not the case for you. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list

Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > See section 1.1 of > > https://www.sqlite.org/src/artifact?ci=trunkfilename=ext/icu/README.txt; > > Simon. It looks good, basically 2 letter ISO 639 language code and ISO 3166 country code. -- Sent from: http://sqlite.1065341.n5.nabble.com/

Re: [sqlite] UPPER function depends on Locale?

On 9 Apr 2018, at 8:49pm, sandu wrote: > I am also curious about how can someone define the locale parameter for the > LOWER/UPPER functions? See section 1.1 of Simon.

Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > Unfortunately, bare SQLite understands only ASCII characters. It does not > understand Unicode. To build in full understanding of Unicode would make > SQLite almost twice as long. > > However, you can add Unicode support to SQLite using ICU: > >

Re: [sqlite] UPPER function depends on Locale?

According to SQLite documentation, it does not depend on locale, because it is a pure ASCII implementation: "The upper(X) function returns a copy of input string X in which all lower-case ASCII characters are converted to their upper-case equivalent." ASCII character was designed for English US,

Re: [sqlite] UPPER function depends on Locale?

> Le 9 avr. 2018 à 11:39, Dr. Mucibirahman İLBUĞA a > écrit : > > 09.04.2018 11:08 tarihinde Olivier Mascia yazdı: >> Is it better / simpler to write your own UPPER/LOWER specialised or to >> simply rebuild SQLite with ICU, I have too few details on your needs / goals

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 11:08 tarihinde Olivier Mascia yazdı: Is it better / simpler to write your own UPPER/LOWER specialised or to simply rebuild SQLite with ICU, I have too few details on your needs / goals to tell. Hi, Is there any document explains step by step recompiling SQLite with ICU support

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 11:08 tarihinde Olivier Mascia yazdı: Is it better / simpler to write your own UPPER/LOWER specialised or to simply rebuild SQLite with ICU, I have too few details on your needs / goals to tell. Dear Olivier, Thanks a lot for your valuable informations. You may be right about

Re: [sqlite] UPPER function depends on Locale?

> Le 9 avr. 2018 à 08:42, Dr. Mucibirahman İLBUĞA a > écrit : > > 09.04.2018 00:56 tarihinde Simon Slavin yazdı: >> There is another solution which does not involve full ICU support. You >> could instead make your own external functions for UPPER_TR() and LOWER_TR()

Re: [sqlite] UPPER function depends on Locale?

09.04.2018 00:56 tarihinde Simon Slavin yazdı: There is another solution which does not involve full ICU support. You could instead make your own external functions for UPPER_TR() and LOWER_TR() which do just the conversions for Turkish. Presumably they could use tables to look up which

Re: [sqlite] UPPER function depends on Locale?

Dear Simon, OK. Thanks. It seems that I need to make moore Google search about "Recompiling SQLite with ICU"... Regards, Mucip:) On Mon, Apr 9, 2018 at 12:56 AM, Simon Slavin wrote: > On 8 Apr 2018, at 10:51pm, mucip.ilb...@gmail.com wrote: > > > I develop project on

Re: [sqlite] UPPER function depends on Locale?

On 8 Apr 2018, at 10:51pm, mucip.ilb...@gmail.com wrote: > I develop project on QT/C++ and compile both Linux and Windows platforms. > In this case, should I recompile SQLite both of these platforms?! Should I > make some modifications on QT too?! I think you will need to do all these things. I

Re: [sqlite] UPPER function depends on Locale?

Dear Simon, I develop project on QT/C++ and compile both Linux and Windows platforms. In this case, should I recompile SQLite both of these platforms?! Should I make some modifications on QT too?! By the way is there any good guidence to add ICU support to SQLite both Linux and Windows

Re: [sqlite] UPPER function depends on Locale?

On 8 Apr 2018, at 9:55pm, Dr. Mucibirahman İLBUĞA wrote: > As you see above table it returns incorrect. Only i>>I is working like in > English language?! When I use this code in PostgreSQL it works correct. But I > got unexpected result in SQLite unfortunatelly. Thank

Re: [sqlite] UPPER function depends on Locale?

08.04.2018 23:23 tarihinde Simon Slavin yazdı: Can you paste into a reply to this message some lower-case Turkish text, what you expect to get, and what you are getting instead ? It would be useful to have an example of what is going wrong. Dear Simon, First of all thanks a lot for your

Re: [sqlite] UPPER function depends on Locale?

On 8 Apr 2018, at 12:50pm, Dr. Mucibirahman İLBUĞA wrote: > The UPPER function is not working properly in Turkish language?! How can I > get this? > > For example small "i" is equal to big "I" in Turkish language. But it's not > working properly?! Can you paste into