MSSQL field 'uniqueidentifier' is returned as str formatted as byte str

[dryo]

When fetching a value from a column of type 'uniqueidentifier' a str is returned that includes the representation of a bytestr.

Example
The data in the column is E3A61520-F8C9-434F-A153-9B2E8C136430.

When fetched via pypyodbc with e.g. {ODBC Driver 13 for SQL Server} and stored in value this happens:

print(str(type(value)) + ', ' + repr(value))
<class 'str'>, "b'E3A61520-F8C9-434F-A153-9B2E8C136430'"

This looks different from this:

testvalue = b'E3A61520-F8C9-434F-A153-9B2E8C136430'
print(str(type(testvalue)) + ', ' + repr(testvalue))
<class 'bytes'>, b'E3A61520-F8C9-434F-A153-9B2E8C136430'

I'm using windows with python 3.6.5 and pypyodbc 1.3.4.

Possibly related: #54, #46, #25

[junctionapps]

see #78
Does that help you out?

[junctionapps]

summary from @braian87b
In pypyodbc.py:

change:
SQL_GUID : (str, str, SQL_C_CHAR, create_buffer, 2048 , False ),
to:
SQL_GUID : (str, lambda x: x, SQL_C_CHAR, create_buffer, 2048 , False ),

Like on the SQL_VARCHAR line.

[dryo]

Sorry, did not see #78 as I was only searching open issues.
This however did not do the trick or I forgot something. I changed the file "C:\Program Files\Python36\Lib\site-packages\pypyodbc.py". No difference. I renamed "C:\Program Files\Python36\Lib\site-packages_pycache_\pypyodbc.cpython-36.pyc.bak". No difference - and to my surprise the file was not recreated.