Skip to main content

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;;

Be the first to reply!

Reply