topic Re: UnicodeEncodeError in Python Questions

UnicodeEncodeError

CliveSwan — Wed, 27 May 2015 17:49:57 GMT

I cannot retrieve records for a Arc/Oracle database

I get an "UnicodeEncodeError: 'ascii' codec can't encode character" error

snippet of the code:

sdeConn = arcpy.ArcSDESQLExecute(sde_conn_file)

for tbl in tableList:

try:

userValue = "u'"

val = ''.join([x for x in userValue if ord(x) < 128])

sdeReturn = sdeConn.execute("SELECT * FROM DBA_OBJECTS" )

The records are printed out as:

[u'GISADMIN.KCC_KHS_CUSTOMER_LKP', u'GISADMIN.KCC_KHS_DISTRICT_LKP']

I tried to use a CSV.writer - did nothing??

def writerows(self, rows):

file = open(output_file, 'wb')

for row in rows:

print row

self.writerow(row)

file.close()

I would appreciate assistance to get the CSV.writer working...

Thanks,

Clive

CliveSwan — Thu, 28 May 2015 10:16:10 GMT

This has a working example of the CSV.Writer class.

Still getting an unicode error from the SQL statement:

sdeReturn = sdeConn.execute("SELECT * FROM DBA_OBJECTS" )

CliveSwan — Thu, 28 May 2015 11:17:06 GMT

The script should return:

The code works on Database a

[u'USER, u'TABLE', u'Data1', u'Data2']

The u seems is needed for a new column, within the recordset.

The same script returns an error on Database b, an older database??

HåvardMoe — Mon, 01 Jun 2015 14:30:26 GMT

Which line of code is mentioned in the error message, and what's the full message? There should be a mention of the character in question there