Character error reading sql database using Python

Question

I'm trying to read a SQL database and show some information on a tkinter label, but the character 'ã' is being displayed as '?'. How to fix this?

This is the code I used:

from sqlalchemy import create_engine
oracle_connection_string = 'oracle+cx_oracle://{username}:{password}@{hostname}:{port}/{database}'
engine = create_engine(
oracle_connection_string.format(
    username='xxx',
                    password='xxx',
                    hostname='xxx',
                    port='xxx',
                    database='xxx',
                    )
                )
        string_find_table = """ SQL View """
data = pd.read_sql(string_find_table, engine)

Amjad Al Taleb · Accepted Answer · 2020-05-18 20:41:38Z

1

This is an encoding error, check this post: UnicodeDecodeError with pandas.read_sql

edited May 18, 2020 at 20:41

answered May 18, 2020 at 18:50

Amjad Al Taleb

1515 bronze badges

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

Collectives™ on Stack Overflow

Character error reading sql database using Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related