Description: Items are not sorted alphabetically. I have the impression that the 0 is not taken into account. Steps to Reproduce: Create queries on LibreOffice 24. Actual Results: I have the impression that the 0 is not taken into account. example query name: Classification by Libreoffice Base (illogical) R_ALBUM_B01 R_ALBUM_B10 R_ALBUM_B11 R_ALBUM_B13 R_ALBUM_B0013 R_ALBUM_B14 R_ALBUM_B15 R_ALBUM_B0016 Expected Results: Alphabetical classification (logical) R_ALBUM_B0013 R_ALBUM_B0014 R_ALBUM_B0016 R_ALBUM_B01 R_ALBUM_B10 R_ALBUM_B11 R_ALBUM_B13 R_ALBUM_B14 Reproducible: Couldn't Reproduce User Profile Reset: No Additional Info: Include the number 0.
Sorting depends on the collation the database will use. So: Which database do you use? → internal HSQLDB? → internal FIREBIRD? → any external database? Would be good to upload an example as attachment here.
(In reply to Robert Großkopf from comment #1) > Sorting depends on the collation the database will use. > So: Which database do you use? > → internal HSQLDB? > → internal FIREBIRD? > → any external database? > > Would be good to upload an example as attachment here. LibreOffice Version 24.8.6.2
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. Please test in safe mode, Menu/Help/Restart in Safe Mode
@KFDM : please specify the type of embedded database you are using, either embedded HSQLDB, or embedded Firebird DB. If you are not using an embedded database, please provide the db engine/server you are connecting to, the manner in which you connect (i.e. database driver conenction type, version and configuration), and a sample table or SQL dump with data content, and which illustrates the problem in LibreOffice.
See also bug 124054
(In reply to Alex Thurgood from comment #4) > @KFDM : please specify the type of embedded database you are using, either > embedded HSQLDB, or embedded Firebird DB. > > If you are not using an embedded database, please provide the db > engine/server you are connecting to, the manner in which you connect (i.e. > database driver conenction type, version and configuration), and a sample > table or SQL dump with data content, and which illustrates the problem in > LibreOffice. The database comes directly from Libre Office. Without going through a server (directly on the PC) PC configuration: Processor: 13th Gen Intel(R) Core(TM) i5-13400F 2.50 GHz RAM: 32.0 GB (31.8 GB usable) System type: 64-bit operating system, x64 processor Edition: Windows 11 Professional Version: 23H2
(In reply to KFDM from comment #6) > (In reply to Alex Thurgood from comment #4) > The database comes directly from Libre Office. > Without going through a server (directly on the PC) > PC configuration: > Processor: 13th Gen Intel(R) Core(TM) i5-13400F 2.50 GHz > RAM: 32.0 GB (31.8 GB usable) > System type: 64-bit operating system, x64 processor > Edition: Windows 11 Professional > Version: 23H2 Cela n'est malheureusement pas la réponse à la question posée. Il s'agit donc a priori d'une base de données dite "embarquée", c-a-d soit Hsqldb, soit Firebird. Laquelle de ces deux? Il nous faudrait un échantillon de cette base avec la table problématiquevet données de test, sinon comment va-t-on savoir comment tu l'as définie ?
(In reply to Alex Thurgood from comment #7) > (In reply to KFDM from comment #6) > > (In reply to Alex Thurgood from comment #4) > > > The database comes directly from Libre Office. > > Without going through a server (directly on the PC) > > PC configuration: > > Processor: 13th Gen Intel(R) Core(TM) i5-13400F 2.50 GHz > > RAM: 32.0 GB (31.8 GB usable) > > System type: 64-bit operating system, x64 processor > > Edition: Windows 11 Professional > > Version: 23H2 > > Cela n'est malheureusement pas la réponse à la question posée. > Il s'agit donc a priori d'une base de données dite "embarquée", c-a-d soit > Hsqldb, soit Firebird. Laquelle de ces deux? > > Il nous faudrait un échantillon de cette base avec la table problématiquevet > données de test, sinon comment va-t-on savoir comment tu l'as définie ? Base embarqué = HSQLDB.