Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Problem with FJSONParser
Hi, I am using copy local with FJSONParser to import data.
The problem is, when the JSON consists of escaped unicode letters like \u00e1 (in database stored as 0xDCC3], The import is mangled.
I tried to import the same file using Unix ODBC in Linux, in Windows via JDBC, Python in Linux, vsql directly on one of the nodes (locale set to en_US.UTF-8 on all nodes). I always get the same result. An ideas what may be wrong.
Thank You for help.
Tagged:
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Problem solved. The field was to short, therefore truncation occurred and data got mangled. Surprising was, that copy did not abort (ENFORCELENGTH ABORT ON ERROR).