On Mar 11, 1:19 pm, gintare <g.statk...@gmail.com> wrote:
> Hello,
>
> How to save special characters: å , ö, ä...
>
> I tried to write them in browsers input field in several ways:
> å , ö, ä...
> \xc3\xa5 , \xc3\xa4, \xc3\xb6
>
> I am using sqlite syntax for saving
> from HTML tetxtarea
> to the sqlite3 database textfield:
> models.CharField(max_length=500, blank=True, default='').
>
> for i in range(len(Ltitles)): stLtit=stLtit
> +smart_unicode(Ltitles[i], encoding='utf-8', strings_only=False,
> errors='strict')+' , '
> st2='INSERT into Ath_aref'+ ' ('+stLtit+') VALUES '+'('+stLq
> +');' ; print 'my_custom_sql st2=', st2
> cursor.execute(st2); st2=''
> transaction.commit_unless_managed()
>
> regards
> gintare statkute
1. Why are you using custom SQL when Django takes care of this for
you?
2. Why are you using bytestrings rather than Unicode strings?
3. Why are you inserting POSTed data directly into database commands,
rather than using parameterized queries, leaving yourself open to SQL
injection?
--
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-us...@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.
