Qbox-project / txAdminRecipe

http://qbox-project.github.io
11 stars 52 forks source link

fix(sql): enforce collation on name column #83

Closed solareon closed 3 months ago

solareon commented 3 months ago

Description

CitizenID is a generated field that has a charset of A-Z 0-9. Forcing this to a certain collation is counterintuitive as it doesn't support unicode characters. The issue that was supposed to be resolved by this is for the name field being unpopulated due to players with unicode characters in their name within the fivem client. This corrects that issue as well as streamlining qb-core users migrating to qbx_core.

Checklist

solareon commented 3 months ago

image From the discord when this issue was discovered.