Getting UnicodeEncodeError while loading data from DynamoDB in python

Question

The error I encountered while taking data from DynamoDB;

UnicodeEncodeError: 'charmap' codec can't encode character '\u2019' in position 1761: character maps to

Codes;

self.db = boto3.resource(
        'dynamodb',
        region_name=Config.AWS_DB_REGION_NAME,
        aws_access_key_id=Config.AWS_DB_ACCESS_KEY,
        aws_secret_access_key=Config.AWS_DB_SECRET_KEY
)
self.tableName = "test"

queryAll():
    self.actionTable = self.db.Table(self.tableName)

    query = self.actionTable.scan(
        ProjectionExpression='id, cityName, title, lat, lng',
        FilterExpression=Attr("type").eq("attraction")
    )

    return query

venues = queryAll()

print("Found Records: {}\n".format(str(venues['Count']) + "/" + 
str(venues['ScannedCount'])))
founds = list()

if venues['Count']:
 for i, item in enumerate(venues['Items']):
    if "lat" in item:
        founds.append(
            {
                "id": item["id"],
                "title": str(item["title"]),
                "location": str(item['lat']) + "," + str(item['lng'])
            })
print(founds)
Items = venues['Items']
exit()

please change your title, it's too filthy. can you please provide full error stack please. — jits_on_moon
– jits_on_moon, Commented Jul 16, 2018 at 13:47
@Mr.J, I can not write the data I added to the founds variable — Abdullah Bozdağ
– Abdullah Bozdağ, Commented Jul 16, 2018 at 13:59
which line from above code is causing error? i need error details not source code or input — jits_on_moon
– jits_on_moon, Commented Jul 16, 2018 at 14:00

Abdullah Bozdağ · Accepted Answer · 2018-07-16 14:33:57Z

1

solve the problem with this function

.encode('ascii','ignore').decode()

using;

"title": str(item["title"]).encode('ascii','ignore').decode(),

answered Jul 16, 2018 at 14:33

Abdullah Bozdağ

1363 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting UnicodeEncodeError while loading data from DynamoDB in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related