AdventureWorksLT since 2016 have wrong unicode characters in ProductDescription table

Open

#1,360 opened on Nov 4, 2024 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 3/5
Estimated time: 1-2 days
Newbie friendliness: 35/100

Issue type: Bug
Clarity: Mostly clear
Activity status: Stale
Tech stack: sql
Domain: databases

Research direction

Start by inspecting the AdventureWorksLT 2016 backup and the ProductDescription table, focusing on the Description column from ProductDescriptionID 1360 onward. Compare the affected values with the intended text and verify that the corrected backup no longer contains wrongly decoded Unicode characters.

Written by the indexing model from the issue text.

Description

As mentioned in the title - starting from the AdventureWorksLT 2016 backup there are wrong characters / wrong decoding in the Description column in the ProductDescription table. You may observe them starting from the ProductDescriptionID = 1360 and higher.

Dominant language: PowerShell
Stars: 11.2k
Forks: 9.1k
Avg merge: 2d 7h
Merged PRs (30d): 14

Contributor guide

No contributing guide indexed for this repository

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

[Bug]: session_search misses a short non-Latin query typed in the other case Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

use-agent-os/agent-os#3312 · Opened Sep 22, 2026
Document that a SQLite trail allows only one writer Open

documentation help wanted

Difficulty 2/5 1-3 hours Newbie friendliness 90/100

rajfirke/provena#202 · Opened Sep 22, 2026
Batched `completeJobs`/`failJobs` are never retried: the retry loop in `batch()` exits after the first failure Open

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

graphile/worker#636 · Opened Sep 21, 2026
Test Failure: com.ibm.ws.jdbc.fat.sqlserver.SQLServerTest J2CA0079E Open

Difficulty 2/5 1-3 hours Newbie friendliness 72/100

OpenLiberty/open-liberty#35839 · Opened Sep 21, 2026
hash join v2: 'unsupported column type for pre-alloc 225' when joining on a VECTOR column Open

affects-9.0 found-by-ai may-affects-25.10 may-affects-26.3 may-affects-26.9 may-affects-7.5 may-affects-8.1 may-affects-8.5 severity/major sig/execution type/bug

Difficulty 2/5 1-3 hours Newbie friendliness 85/100

pingcap/tidb#71473 · Opened Sep 21, 2026

More Databases issues