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? >>> >>> >>>

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql

2018-06-30 Thread Lukasz Szybalski
On Friday, April 27, 2018 at 4:05:20 PM UTC-5, Lukasz Szybalski wrote: > > > > On Thursday, January 18, 2018 at 11:49:39 AM UTC-6, Mike Bayer wrote: >> >> >> >> On Thu, Jan 18, 2018 at 12:31 PM, Lukasz Szybalski >> wrote: >> >>> Hello, >>> I have a query in sqlalchemy like below where I lookup

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql

2018-04-27 Thread Lukasz Szybalski
On Thursday, January 18, 2018 at 11:49:39 AM UTC-6, Mike Bayer wrote: > > > > On Thu, Jan 18, 2018 at 12:31 PM, Lukasz Szybalski > wrote: > >> Hello, >> I have a query in sqlalchemy like below where I lookup contract# in >> mssql. How do I enforce the varchar instead of

Re: [sqlalchemy] NVARCHAR vs VARCHAR in mssql

2018-01-18 Thread Mike Bayer
On Thu, Jan 18, 2018 at 12:31 PM, Lukasz Szybalski wrote: > Hello, > 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.

[sqlalchemy] NVARCHAR vs VARCHAR in mssql

2018-01-18 Thread Lukasz Szybalski
Hello, 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? You can find that the query that