Linked Questions
17 questions linked to/from MySQL "incorrect string value" error when save unicode string in Django
206
votes
28
answers
490k
views
How to fix "Incorrect string value" errors?
After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns to use the utf8 column charset and the default column ...
3
votes
6
answers
11k
views
With Laravel, can you change a column name as part of a migration?
Pretty much just what the title says; I need to change a column name as part of a migration, can that be done and if so, how?
5
votes
2
answers
4k
views
Emoticons from iPhone to Python/Django
I'm trying to save comments from an iPhone app that may and nowadays most likely will include emoticons. No matter what I do, I can't save the emoticons to the MySQL database ... Constant Unicode ...
1
vote
2
answers
4k
views
"Incorrect string value" when trying to insert String into MySQL via Python and Text file
What is causing this incorrect string? I have read many questions and answers and here are my results. I still am getting same error after reading answers.
I am getting the following error:
ERROR ...
1
vote
1
answer
3k
views
Encoding troubles with python, mysql and utf8mb4
I get the following warnings, when trying to save a simple dataframe to mysql.:
C:...\anaconda3\lib\site-packages\pymysql\cursors.py:170: Warning: (1366, "Incorrect string value: '\x92\xE9t\xE9)' ...
0
votes
2
answers
978
views
Why does a utf8mb4 column reject 4-byte characters in MySQL 5.7.22?
I'm trying to save a string of all 4-byte characters to a MySQL utf8mb4 column.
UPDATE `uga_libsteam`.`group_history` SET `source_name`='Empress' WHERE `group_id`='103582791430024497' and`...
2
votes
1
answer
1k
views
Django with MySQL and UTF-8 [duplicate]
Possible Duplicate:
How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
Background:
I am using Django with MySQL 5.1 and I am having trouble with 4-byte UTF-...
5
votes
0
answers
671
views
django loading fixtures fails on unicode data
I saved a bunch of fixtures via dumpdata, here is an example:
[
{
"pk": 1,
"model": "core.question",
"fields": {
"text": "\u041a\u0430\u043a\u0438\u0445 \u0436\u0438\u0432\u043e\...
1
vote
1
answer
372
views
Unicode charactered filename SELECT SQL parameter issue
I have a webapp/webservice method created in django, which stores unicode character filenames on a DB-table. I am doing it by this method on the views.py script:
SubmissionContents(id=subid, filename=...
0
votes
1
answer
375
views
Hibernate DataException on saving Č, Ć characters
As the title says, I'm using Hibernate ORM and whenever I try to save something with Č or Ć in it hibernate throws "couldn't execute query" error. I am using utf8, and Š, Ž, Đ characters work just ...
0
votes
2
answers
363
views
Django polls with autentication
I have a poll app using django from the docs. I now want to make it advanced. I dont want a user to be able to vote twice that means the users can only vote once else it would show an error message. ...
King's user avatar
- 2,053
0
votes
1
answer
349
views
Incorrect string value when running GeoDjango tutorial: "Warning: Incorrect string value"
Note: Copying and elaborating upon this question and answer from: https://groups.google.com/forum/?fromgroups=#!topic/django-users/OW_uSWCoObs:
Hi, I was trying to go through the GeoDjango tutorial ...
0
votes
3
answers
273
views
OperationalError at / no such table: blog_post_categories
I'm trying to add category section to my blog pet-project; I feel that I almost there, but on the last part of work it showed me an error:
"OperationalError at / no such table: blog_post_categories"
...
1
vote
0
answers
175
views
Incorrect string value error on inserting Unicode value alchemy [duplicate]
I am using SQL alchemy in python to connect with the SQL database. I am inserting a value "சிறார்கள்" in the form.
i receive this value as
editedProduct = dbsession.query(Product).filter_by(id=...
1
vote
1
answer
91
views
Save unicode pictograms to mysql
I have some code (at django server) that writes json data contained in POST requests into mysql db.
Some requests contain specific pictograms like 📸 or 🦁.
Those are supposed to be written to a ...