how can I save persian numbers in database (mysql)

Question

I'm developing a telegram bot with python.

I ask users to input their phone numbers. The problem is, if they enter Persian numbers (like ۰۶۰۷۵۰), their data doesn't set in my database, and after updating database its field is empty!

But if they enter English digits, it saves in database?!

python 3.7
database: MySQL
OS: win 10

What is the type of the column you're trying to insert those persian numbers? — vahdet, Nov 12 '18 at 06:45
This post https://stackoverflow.com/questions/3832056/mysql-check-collation-of-a-table/52479645#52479645 should advise how to get table's collation. — Giorgos Myrianthous, Nov 12 '18 at 07:21

score 4 · Accepted Answer · answered Nov 12 '18 at 07:30

4

Convert to the string and save it later in the database

Use the number to convert the number to the number

database----> '۰۶۰۷۵۰'

using ---> get database-----> int('۰۶۰۷۵۰')

answered Nov 12 '18 at 07:30

Reza Bojnordi

703
5
15

1

actually, you mean I should change type of field to text, am I right??? – mahyar madani Nov 12 '18 at 08:12

score 0 · Answer 2 · answered Nov 12 '18 at 08:46

thanks

I solved it without any change to my database!

phone_number = str(phone_number)
print('str:    ', phone_number)
print('str type:    ', type(phone_number))

phone_number = int(phone_number)
print('int:    ', phone_number)
print('int type:    ', type(phone_number))

how can I save persian numbers in database (mysql)

2 Answers2