Pydataset returns â following value

Ignition
1

the following code returns â at the end of the string. If I strip off the last character it doesnt strip the â it strips the last character from my desired value and the â remains. can anyone tell me what im doing wrong?

Query=‘select value from mytable where location = 100’
data = system.db.runQuery(Query,’’)
for row in data:
location = row[“LOCATION”]
print str(location)

2

NM - I changed to the following with no issue:

Query=‘select value from mytable where location = 100’
data = system.db.runQuery(Query,’’)
location = str(data[0][0])
print location

3

If you are only interested in one value, use system.db.runScalarQuery - this either returns one value or null.