id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 21508 ForeignKey cast to int despite being varchar fiomtec@… nobody "Hi! I have a couple of models connected to a read-only sqlserver DB, like this (trimmed to the important details): {{{ class Cliente(models.Model): codigo = models.CharField(max_length=8, primary_key=True) nif = models.CharField(max_length=15) nombre = models.CharField(max_length=100, db_column='nombre_apellidos') class Confirmacion(models.Model): cliente = models.ForeignKey(Cliente, db_column='entidad_propietaria', max_length=8) [...]other fields[...] }}} When I try to find some Confirmacion objects filtering by nif like this: {{{ Confirmacion.objects.filter(cliente__nif=nif).all() }}} it will correctly find some results, but blow up when I try to access them. e.g., this is a dict from one Confirmacion result: {'cliente_id': 7502, '_state': , [...] other fields [...]} the problem is that the correct cliente_id is not 7502, but '007502', and when I try to access that confirmacion.cliente, I get a ""Cliente matching query does not exist"" exception. I also tried using to_field=""codigo"", same result. Am I doing something wrong?. Shouldn't the id be a string since the pk is defined as a charfield?. Thanks." Bug closed Database layer (models, ORM) 1.5 Normal needsinfo Accepted 0 0 0 0 0 0