Bad Row due to Special / Foreign Characters

Moderator: NorbertKrupa

Post Reply
jagadeesh
Newbie
Newbie
Posts: 21
Joined: Tue Feb 05, 2013 9:36 am

Bad Row due to Special / Foreign Characters

Post by jagadeesh » Thu Sep 12, 2013 11:36 am

Hi,

I am trying to load tables in Vertica through Informatica.

Some of my records are rejected due to special/foreign language character data.

I am using UTF-8 code page for source/target relational connection.

session failed as the row rejected due to bad data.

sample reject data "CONGȂEC CAPITAL LTȅ"

Thanks,
Jagadeesh

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Bad Row due to Special / Foreign Characters

Post by JimKnicely » Thu Sep 12, 2013 12:30 pm

Hi,

Are you loading files that are in Linux? If so, try running the file command on them to verify that they are indeed UTF-8 encoded!

Please look over the post http://www.vertica-forums.com/viewtopic.php?f=6&t=1145
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

jagadeesh
Newbie
Newbie
Posts: 21
Joined: Tue Feb 05, 2013 9:36 am

Re: Bad Row due to Special / Foreign Characters

Post by jagadeesh » Fri Sep 13, 2013 10:26 am

Thanks Knicely, but i am extracting data directly from a Database.

I have my relational connection(ODBC) for source and Target(vertica) code page as UTF-8.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Bad Row due to Special / Foreign Characters

Post by id10t » Fri Sep 13, 2013 6:13 pm

Hi!

Informatica runs on Linux or Windows? (if question is stupid: I never met Informatica :( )

Post Reply

Return to “New to Vertica Database Development”