# Invalid byte sequence

**URL:** <https://forum.xojo.com/t/invalid-byte-sequence/78209>\
**Category:** Web\
**Created:** [November 21, 2023, 12:34pm UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209 "2023-11-21T12:34:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Herman\_Dubach](https://forum.xojo.com/letter_avatar_proxy/v4/letter/h/76d3ee/32.png) [@Herman\_Dubach](https://forum.xojo.com/u/Herman_Dubach)\
**Post date:** [November 21, 2023, 12:34pm UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/1 "2023-11-21T12:34:37Z")

</div>

I am migrating from sqLite to postgreSQL. Everything goes as expected, but when I try to add a password field to postgreSQL I get this error.

invalid byte sequence for encoding “UTF8”: 0xa6

The password field is encrypted like this:  
hashValue = Crypto.PBKDF2(kSalt, value, 128, 32, Crypto.HashAlgorithms.SHA512),  
based on the example from Xojo.

How can I solve this?  
Thanks for an answer.

---

<div class="post-metadata">

**Author:** ![Maximilian\_Tyrtania1](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania1/32/16871_2.png) [@Maximilian\_Tyrtania1](https://forum.xojo.com/u/Maximilian_Tyrtania1)\
**Post date:** [November 21, 2023, 1:12pm UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/2 "2023-11-21T13:12:51Z")

</div>

You’ve probably defined your passwordfield as text on Postgres and the server’s encoding as UTF-8. The server just duly tells you that it cannot store non-UTF8 data in a UTF8 text field. Consider using a bytea field for that purpose instead.

---

<div class="post-metadata">

**Author:** ![Herman\_Dubach](https://forum.xojo.com/letter_avatar_proxy/v4/letter/h/76d3ee/32.png) [@Herman\_Dubach](https://forum.xojo.com/u/Herman_Dubach)\
**Post date:** [November 21, 2023, 3:28pm UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/3 "2023-11-21T15:28:49Z")

</div>

Thanks Maximilian, but I get the same error.

---

<div class="post-metadata">

**Author:** ![Maximilian\_Tyrtania1](https://forum.xojo.com/user_avatar/forum.xojo.com/maximilian_tyrtania1/32/16871_2.png) [@Maximilian\_Tyrtania1](https://forum.xojo.com/u/Maximilian_Tyrtania1)\
**Post date:** [November 22, 2023, 6:25am UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/4 "2023-11-22T06:25:12Z")

</div>

How exactly does your SQL look like? And how do you send it from Xojo? What PG version? Also I’d check the postgres log file to see if there is a more explicit error message.

---

<div class="post-metadata">

**Author:** ![Jean-Yves\_Pochez](https://forum.xojo.com/user_avatar/forum.xojo.com/jean-yves_pochez/32/21769_2.png) [@Jean-Yves\_Pochez](https://forum.xojo.com/u/Jean-Yves_Pochez)\
**Post date:** [November 22, 2023, 7:12am UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/5 "2023-11-22T07:12:13Z")

</div>

I usually encodebase64 the hash before storing it in the database.

---

<div class="post-metadata">

**Author:** ![Herman\_Dubach](https://forum.xojo.com/letter_avatar_proxy/v4/letter/h/76d3ee/32.png) [@Herman\_Dubach](https://forum.xojo.com/u/Herman_Dubach)\
**Post date:** [November 22, 2023, 7:45am UTC](https://forum.xojo.com/t/invalid-byte-sequence/78209/6 "2023-11-22T07:45:23Z")

</div>

Thanks, that is the solution.
