MySQL UUID binary encoding incompatible with string parser?

[rynoV]

Hi, thanks for making this project!

I'm trying to use this library with UUID values stored in BINARY(16) columns in MySql 8.0.35. The bytes are being parsed here as UTF8, but I believe it's failing because UUID uses utf8mb3, which is different from System.Text.Encoding.UTF8. For example, a UUID may include bytes like 0x9c and 0x9d, both of which get parsed to 0xfffd:

let b: byte[] = [| byte 0x9c; byte 0x9d |]

let s = Encoding.UTF8.GetString(b)

for ch in s do
    printfn $"%08x{int16 ch} "

>> 0000fffd 
>> 0000fffd 

Have I misunderstood something?

I'm currently planning to make a fork that uses only byte arrays instead of String for string-typed columns

[rynoV]

Here's the fork: main...Auspice-Capital:MySqlCdc:main

[rusuly]

Hi, thanks for your contribution! I merged your fork and uploaded libs to the nuget. Sorry for very late response and slow support, there are reasons for that