'DataFrame showing 'xxxx' instead of correct values

Im selecting data from a SQL Server database into a dataframe. The values in the database are correct addresses.

When I slect the data into a dataframe any varchar value over 50 in length shows up as 'xxxx' in the dataframe. Thats the only difference I can see between the data showing correctly and the data being misrepresented. The code is below.

sql = "Select UserID, City,  Address1,  State, Email from v_viewname"
sql_query = pd.read_sql_query(sql, cnxn)

df = pd.DataFrame(sql_query, columns = ['UserID', 'City','Address1',  'State'])

Has anyone else run into this issue?

Thanks in advance.

python sql-server pandas

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source