Skip to main content
Question

How to check vertica encoding type?

  • July 26, 2021
  • 1 reply
  • 2 views

HyeontaeJu
Forum|alt.badge.img+2

When i use kakfaExport and consume the data this error occred..

Invalid UTF-8 middle byte 0xfc

How to check vertica encoding type?

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • August 4, 2021

Vertica stores data as UTF-8 by default but also supports locale. However, Kafka is likely set to UTF-8 encoding so it may be necessary to force UTF-8 encoding on export data. Please see the blog post on UTF-8 encoding to replace non-UTF-8 characters:
https://www.vertica.com/blog/quick-tip-replacing-non-utf-8-characters/