Options

Problem with FJSONParser

jsipekjsipek Vertica Customer
in General Discussion

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:

Answers

  • Options
    jsipekjsipek Vertica Customer

    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).

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...