Hello The first problem was solved by changing URI from mssql to mssql2 Now DB connection as following and no problem with viewing and saving strings with cyrillic letters.
dbsol = DAL <http://127.0.0.1:8000/examples/global/vars/DAL>('mssql2://user:password@w2ptkts/SacuraOnline', db_codec = 'cp1251', migrate_enabled = False) But the second problem (save the profile with the Cyrillic alphabet) still exist. I don't understand why this is happening? But the second problem (save the profile with the Cyrillic alphabet) still exist. I do not understand why this is happening? Data from the same table, the same connection. Maybe in the implementation of saving Profile skipped recoding code pages? понедельник, 4 августа 2014 г., 14:45:50 UTC+11 пользователь Алексей Котряхов написал: > > > Hello web2pyers > > I have a problem with encoding when I work with MSSQL with codepage other > than latin1 or unicode > Here is my DB connection > > dbsol = DAL > <http://127.0.0.1:8000/examples/global/vars/DAL>('mssql://user:password@w2ptkts/SacuraOnline', > db_codec = 'cp1251', migrate_enabled = False) > > I'm successfully read and and view any tables from my DB. > But when I try to write to my DB, I see strange behavior, like occuring > unwanted (or excessive) encoding. > > Here is example > > Also got an error while saving the profile with Cyrillic letters > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
