166 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
2
answers
143
views
Decompress compressed value of type varchar with UTF-8 collation in SQL Server
I have a table with a column of type VARCHAR(MAX) with COLLATE Latin1_General_100_CI_AS_SC_UTF8 in a SQL Server database.
I want to compress the values in the column with built-in COMPRESS() function. ...
0
votes
2
answers
101
views
postgresql unaccent and case insensitive
I have this query :
select * from entrees
where account_id = 1
and categorie_id = 2
and recurrent = false
and montant < 0
and ABS(montant) >= 50000
and date_de_valeur >= '2025-05-01'
...
1
vote
0
answers
89
views
String Comparisons dropping the values of the string [duplicate]
I am working on the insertion of addresses and other info for a database where addresses can be from multiple countries or in other languages. Below is a summary of what I am doing.
DECLARE @...
0
votes
1
answer
60
views
Why does "COLLATE SQL_Latin1_General_CP1_CI_AS" keep populating in Query Designer?
All of a sudden last week when I start to build my query in SSMS Query Designer, the columns are adding "COLLATE SQL_Latin1_General_CP1_CI_AS" and need an alias. I don't think I changed any ...
2
votes
1
answer
174
views
Fix "Incorrect string value" in sql script
I am trying to import a lot of data into a MariaDB table. I generated a large SQL script file which contains a lot of special characters (mainly μ, °, and NBSP).
I would like to run my script to put ...
-1
votes
1
answer
66
views
AES Encryption and Decryption not giving proper result
SELECT AES_ENCRYPT('fmale', '2b7e151628aed2a6abf7158809cf4f3c') FROM tmp_categorywise_salary_rpt LIMIT 1;
SELECT CAST(AES_DECRYPT('þ*Ë(| ̧R°8ドルÇ©', '2b7e151628aed2a6abf7158809cf4f3c') as UTF8) FROM ...
1
vote
1
answer
110
views
SQL query not returning results when combining collate and escape function using mutated vowels (umlauts)
I have a query just like this:
SELECT DISTINCT name
FROM table
WHERE name COLLATE BINARY_AI LIKE '%ög%' ESCAPE '\';
The expected behavior would be that it returns names containing ög, like:
Högendorf
...
0
votes
0
answers
55
views
COLLATE differences between SQL dumps from primary and replica MySQL servers
I have two identical servers running Apache, MySQL 8.0.35, and PHP 7.4. The servers have one-way asynchronous MySQL replication setup using GTID-based replication. One server is the primary and the ...
1
vote
1
answer
180
views
Using utf-8 in an webpage isn't working properly [duplicate]
I have a mysql database using latin1_swedish_ci collation on the table.
I will present this data on a web page.
I'm trying to use charset=utf8 on the web page that shows the result, but it gives me a ...
1
vote
1
answer
376
views
COLLATE Vietnamese_CI_AI is not working correctly with LIKE '%value%'
I have data in Vietnamese with accents:
Bảo Linh, Ngọc Mai
If I search with query:
select * from profile where fullname COLLATE Vietnamese_CI_AI like '%ao%'
It returns Bảo Linh
Problem is when I ...
1
vote
0
answers
455
views
Different number of bounding boxes per image, tried padding, but boxes with zeros are invalid for training object detection model
I am training a faster r cnn for object detection, or at least trying to. I have an annotated dataset with bounding boxes and labels, however each image has a different number of bounding boxes as ...
0
votes
1
answer
427
views
"collate_fn" for Huggingface Hyperparameter Tuning
I am following this tutorial on how to do hyperparameter tuning with Huggingface and Wandb.
Most of it works but I don't quite understand what the "collate_fn" Function is doing and how I ...
0
votes
1
answer
1k
views
Mysql - convert Tables in Database to diffrent encoding and collate - foreign key constraints are failing
I have a MySQL Database with the Charset utfmb4 and the collate utf8mb4_unicode_ci.
No, I noticed that this influences my search queries where I use like '%grün%'.
This would also match 'Grund'.
I ...
2
votes
1
answer
364
views
divide list to sublists in groovy
I am trying to divide a list of string into 4 sublist (which should have all elements of original list balanced among them). I have tried following approach but i am getting reminder elements into a ...
1
vote
1
answer
353
views
What locale/rule gives this string sort order?
I have subscribed to a cloud drive service. All good until I needed to check that all folders in a long list had been actually uploaded. I realized that the name-based sort order in my local system is ...