#277 UnicodeCol() on mssql creates varchar instead of nvarchar

closed-fixed
Oleg Broytman
None
5
2013-04-28
2013-02-03
Andrew Ziem
No

In SQL Server, varchar is non-Unicode and nvarchar is Unicode

nvarchar
http://msdn.microsoft.com/en-us/library/ms186939.aspx

varchar
http://msdn.microsoft.com/en-us/library/ms176089.aspx

I am using Python 2.7.3 32-bit, Windows 7, sqlobject 1.3.2, adodbapi 2.4.2.2

Discussion

  • Oleg Broytman
    Oleg Broytman
    2013-02-03

    To change the generated column type we can add a method _mssqlType() to SOUnicodeCol. You can see similar methods in sqlobject/col.py.

    Unfortunately, I am not sure it will help. See discussion in ticket [#278].

     

    Related

    Bugs: #278

  • Oleg Broytman
    Oleg Broytman
    2013-02-03

    • assigned_to: Oleg Broytman
     
  • Oleg Broytman
    Oleg Broytman
    2013-02-14

    BTW, whay is the minimal version of MSSQL that supports NCHAR and N''-quoted strings? Is there a way to test if the backend supports them or not?

     
    Last edit: Oleg Broytman 2013-02-14
  • Oleg Broytman
    Oleg Broytman
    2013-04-28

    • status: open --> closed-fixed
     
  • Oleg Broytman
    Oleg Broytman
    2013-04-28

    Fixed in the revision 4585. Thank you for your help!