special characters in columns are in wrong encoding

Googles response from the server is in UTF-8 but some columns maintain their original charset, so your Umlauts or other special charaters will look defect ( e.g. campaignName).
To fix it, you can use TO_CHARS and TO_BYTES.

In Germany these columns are often encoded in windows-1252, so your view can be fixed like in this Example:
 
create view views.adwords_clicks_per_campaign
AS select
        adwords.customer_id.customerId
        ,campaignId
        ,CAST( TO_CHARS( TO_BYTES( "campaignName", 'windows-1252' ) , 'UTF-8' )  as string ) as "campaignName"
        ,accountId
        ,clicks
    from
        adwords.customer_id
        ,table (
            exec "adwords"."getCAMPAIGN_PERFORMANCE_REPORT" (
                adwords.customer_id.customerId
                ,'2013-01-01'
                ,curdate (
                )
                ,'AccountId,Clicks,campaignId,campaignName'
            )
        ) a;;

Articles in this section

Comments

Articles in this section

Related articles