the trait sqlx::Decode<'_, sqlx::Any> is not implemented for u64

[victorteokw]

Hi,

Thanks for this great library. 👍

Bug Description

The error message prevents compiling which is:

the trait `sqlx::Decode<'_, sqlx::Any>` is not implemented for `u64`

Info

• SQLx version: 0.6.2
• SQLx features enabled: ["sqlx/mysql", "sqlx/any", "sqlx/chrono", "sqlx/runtime-tokio-native-tls"]
• Database server and version: MySQL 8.0.28
• Operating system: macOS 13.0
• rustc --version: 1.64.0

[abonander]

Not a bug. Most SQL databases either don't support unsigned integers, or require an extension.

[victorteokw]

Thanks @abonander,

I just searched the google and understand that PostgreSQL and SQLite don't support unsigned integers.

But in my MySQL database, these columns are defined as UNSIGNED BIGINT or UNSIGNED TINYINT, how can I decode it with sqlx?

Thanks