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;;
Comments
0 comments
Please sign in to leave a comment.