I am kind of a noob when it comes to coding. I can do some basic PHP and HTML - and that's how far it goes. I have a wordpress site sind 2009 and in the time being it created…
How to sort text in PostgreSQL in Latvian alphabetic order, so any letter without accent always comes before the letter with accent? For example this select * from ( select 'bā' as name union select 'āa' union select 'ac' union…
I'm using Django and DRF searchFilter, which allows me to add fields to the view's 'search_fields' to allow searching in them. Django version is 3.2 (will probably upgrade to 4.2) and DRF version 3.12.2. Lately I've added a new field…
I am using PHP 8.1 and MySQL 8.0. All databases, tables and individual fields are all set to a collation of utf8mb4_0900_ai_ci - except for databases: information_schema and performance_schema, which are utf8mb3_general_ci (system default?). Here are the global variables MySQL…
I've a bit of a strange issue going on. My database is set to the utf8mb4_unicode_ci collation. So are the (WooCommerce) tables within that database. The columns in the table are also at utf8mb4_unicode_ci. I've create a view and now…
For my database I want natural ('A2'<'A12'), case-insensitive sorting, so for testing I created a new collation with CREATE COLLATION tomscollation (provider = icu, locale = 'de-u-kn-true-ks-level2'); My end goal is to use such a collation as the default collation…
I want to sort test last name and test2 last name so that the former comes before the latter. My understanding is that each character is compared from left to right until they differ and therefore the characters after those…
I have not been able to get locale-dependent functions such as strcoll() to work in C. I am wondering whether I am doing something wrong and/or how to get this to work. Here is a sample program from this book:…
In Postqresql, I have this query: select * from students where name like '%Huseyin%' When I run it, I want to get data that has name is "Huseyin", "Hüseyin", "Huseyın", "Hüseyin". How can I do this? I use Dapper. I…
I'm trying to switch to MariaDB from mysql 8. I downloaded latest MariaDb 10.10.1 RC version, trying to import backup created from mysql using mysqldump and I get the following error Unknown collation 'utf8mb4_0900_as_cs' What is the equivalent collation in…