Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql + convert_unicode='force' Syntax?

2018-10-08 Thread Mike Bayer
Im working on getting off bitbucket but maybe it's an ad blocker? try a private window or something On Mon, Oct 8, 2018 at 6:36 PM Lukasz Szybalski wrote: > > > On Mon, Oct 8, 2018 at 9:56 AM Mike Bayer > wrote: > >> >> >> On Mon, Oct 8, 2018 at 10:28 AM Lukasz Szybalski >> wrote: >> >>> >>>

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql + convert_unicode='force' Syntax?

2018-10-08 Thread Lukasz Szybalski
On Mon, Oct 8, 2018 at 9:56 AM Mike Bayer wrote: > > > On Mon, Oct 8, 2018 at 10:28 AM Lukasz Szybalski > wrote: > >> >> I have a query in sqlalchemy like below where I lookup contract# in >> mssql. How do I enforce the varchar instead of nvarchar? I tried >> converting >> my field

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql + convert_unicode='force' Syntax?

2018-10-08 Thread Mike Bayer
On Mon, Oct 8, 2018 at 10:28 AM Lukasz Szybalski wrote: > > I have a query in sqlalchemy like below where I lookup contract# in mssql. > How do I enforce the varchar instead of nvarchar? I tried converting my > field to "str(mycurrent)" but that didn't do anything. Is there some other

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql + convert_unicode='force' Syntax?

2018-10-08 Thread Lukasz Szybalski
> I have a query in sqlalchemy like below where I lookup contract# in mssql. How do I enforce the varchar instead of nvarchar? I tried converting my field to "str(mycurrent)" but that didn't do anything. Is there some other spot to force VARCHAR to be sent? >>> >>> >>>