2000 is AL16UTF16. But since there should be a non-lossy conversion
between AL32UTF8 and AL16UTF16 you'd think that Oracle would perform
it and use the index. Puzzling.
Furthermore, when you look in the Oracle db driver you can see in
base.py where it sets NLS_LANG to ".UTF8". This is an old setting for
Oracle and I think it should probably be ".AL32UTF8" for modern
installs. But that doesn't explain where the AL16UTF16 is coming
from... is there a tsnames.ora file involved somewhere?
IDK. I've reached the end of what I know about character sets, Django,
and Oracle :)
On Fri, Jan 23, 2015 at 4:42 AM, Joris Benschop
<joris.bensc...@gmail.com> wrote:
> As an addition:
>>>>x=Marker.objects.raw("SELECT * from VARIANT_CLONE.MARKER WHERE
>>>> MARKID='TO1'")
> This is also slow
>
> so it indeed seems to be a locale issue
> the database is AL32UTF8
> and django uses national character set id "2000"
>
> is this a locale issue?
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/c33b7fc9-e06f-45b0-a677-fc950247dd25%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAD4ANxWGWRUj-r6UvR6jm0qKmrYk%2BO2h2O3fhPykkMkDtrV8fw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
