Thx! But I have the correct chcp coding. I can write swedish signs in the promt, it is when I try to add them in the SQLite3 dB it goes wrong.
I believe it is the "python manage.py shell" that can't handle swedish signs. If I insert an object containing swedish signs from the admin site and read it out in the "manage.py shell" I get weir signs. Are there any other APIs I can use against the database? Best regards Daniel On Feb 15, 2:00 pm, Daniel Roseman <roseman.dan...@googlemail.com> wrote: > On Feb 15, 12:53 pm, DaSa <daniel.sandb...@gmail.com> wrote: > > > > > Hi, > > > Maybe this is a SQLite question, but a guess many Django users uses > > SQLite3. > > > I have a lot of data that I want to export to my SQLite3 database. My > > problem is that the data contains special signs (swedish åäö) and > > therefore is it not possible to insert the data through "windows > > command prompt" (and SQLite3 shell) because the windows command prompt > > does not support swedish signs. > > > It works when I,am adding the data through my admin site (Django > > default admin site), but because of the amount of data it is not > > possible to add the item one and one. > > > My question are if there are any more ways of inserting the data into > > the SQLite3 dB? Is it possible to open the SQLite3 shell without CMD? > > > Thx! > > > Best regards > > Daniel Sandberg > > I don't know the answer - or anything about sqlite3 on Windows - but > it is possible to change the character encoding on the Windows command > shell. See the 'chcp' command, you should be able to find the correct > one to allow you to use Swedish characters. > -- > DR. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
