UnicodeEncodeError: ‘decimal‘ codec can‘t encode characters in position 0-3: invalid decimal Unicode

碰到个UnicodeEncodeError错误

Traceback (most recent call last):
  File "D:\giteecode\xx\views.py", line 1261, in issuelistcount
    issuetypeitem.name, tmpids)
  File "D:\giteecode\xx\utils.py", line 146, in getMapsByIssuetype_jdb
    for each in FlowStepActor.objects.filter(flowstep__template__flowtype_id=issuetype,flowstep__template_id__in=tmpids,actor_type='user').values('flowstep_id','actor_id','flowstep__sequence','flowstep__template_id'):
  File "C:\Python27\lib\site-packages\django\db\models\manager.py", line 122, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 790, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 808, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File "C:\Python27\lib\site-packages\django\db\models\sql\query.py", line 1243, in add_q
    clause, _ = self._add_q(q_object, self.used_aliases)
  File "C:\Python27\lib\site-packages\django\db\models\sql\query.py", line 1269, in _add_q
    allow_joins=allow_joins, split_subq=split_subq,
  File "C:\Python27\lib\site-packages\django\db\models\sql\query.py", line 1199, in build_filter
    condition = lookup_class(lhs, value)
  File "C:\Python27\lib\site-packages\django\db\models\lookups.py", line 19, in __init__
    self.rhs = self.get_prep_lookup()
  File "C:\Python27\lib\site-packages\django\db\models\fields\related_lookups.py", line 98, in get_prep_lookup
    self.lookup_name, self.rhs)
  File "C:\Python27\lib\site-packages\django\db\models\fields\__init__.py", line 744, in get_prep_lookup
    return self.get_prep_value(value)
  File "C:\Python27\lib\site-packages\django\db\models\fields\__init__.py", line 976, in get_prep_value
    return int(value)
UnicodeEncodeError: 'decimal' codec can't encode characters in position 0-3: invalid decimal Unicode string

UnicodeEncodeError是统一编码错误的意思，通过这个我们知道是编码的错误。

一定要记得这个错误类型。

然后看错误内容

'decimal' codec can't encode characters in position 0-3: invalid decimal Unicode string

decimal是十进制的意思。

这个错误内容就是十进制的数据编码错误，知道是数据问题，就好好检查我们的代码，哪里用到了十进制类型的数据。

FlowStepActor.objects.filter(flowstep__template__flowtype_id=issuetype,flowstep__template_id__in=tmpids,actor_type='user')

错误代码中我们用到的十进制数无非就是id类的，估计就是传入的数据有问题，把这些数据打印出来看看

果然是flowstep__template__flowtype_id传值有问题，传了个中文。

是不是很简单的解决的问题，思路清晰。

希望你们碰到问题也能一步步来解决问题，下次碰到UnicodeEncodeError是不是就不会慌了。