The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

How can I determine if data consists of valid utf-8 characters?

How can I determine if data consists of valid utf-8 characters? What causes this: " ERROR: regexp pattern error at offset 25: invalid UTF-8 string"?

Comments

  • As of version 4.1.6 and later, the isutf8() function can be used for determining if string consist of valid UTF-8 characters. This function tests whether a string is a valid UTF-8 string. Returns true if the string conforms to UTF-8 standards, and false otherwise. Best practice is to avoid loading non UTF-8 data into the database.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.