Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Merlin Moncure
On Mon, Apr 3, 2017 at 4:42 PM, Kenneth Shaw wrote: > UTF-8 works just fine with MS SQL: > > ms:booktest@192.168.1.5=> select N'这是一个'; > col0 > +--+ > 这是一个 > (1 rows) confirmed! merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Kenneth Shaw
UTF-8 works just fine with MS SQL: ms:booktest@192.168.1.5=> select N'这是一个'; col0 +--+ 这是一个 (1 rows) You need to use a "unicode" string, as indicated here using N''. You might be able to change the default behavior in SQL Server to treat strings as unicode strings, by changing the d

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Kenneth Shaw
This doesn't seem to be a problem with PostgreSQL, MySQL, Oracle, or SQLite3 databases. It was a problem with MSSQL in the limited check that I just did. I don't see any driver option for the MSSQL Go driver. I'll poke around and see if there's a "client encoding" option. -Ken On Tue, Apr 4, 201

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Karsten Hilbert
On Tue, Apr 04, 2017 at 03:48:16AM +0700, Kenneth Shaw wrote: > It should work. What database did you try that with? I haven't tried > to do heavy / extensive utf8 tests, but all of Go (including the > "readline" package that is used for capturing input are native utf8. > The problem is potentiall

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Kenneth Shaw
On Mon, Apr 3, 2017 at 8:51 PM, Merlin Moncure wrote: > Wow! this is _fantastic_. I use "sqsh" for connecting to sql server > -- this is already a significant improvement in many ways (based on > playing around for around 10 minutes). This app would fill a real > need for me. Here is some feedb

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-03 Thread Merlin Moncure
On Sun, Apr 2, 2017 at 7:55 AM, Kenneth Shaw wrote: > Hi All, > > I apologize in advance if this is somewhat off-topic, but I thought I > would inform the people (ie, psql users) about usql, a > universal-command line tool that aims to work the same way psql does, > but with every database (not ju

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-02 Thread Kenneth Shaw
Unfortunately, the \d* commands aren't implemented yet, as there's a lot of research that needs to be done for all the key databases, which I just haven't had time to do yet. But that's coming very soon (tm)!** The main work done so far has been just getting the cli up to something usable. ** for

Re: [GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-02 Thread Andy Colson
On 04/02/2017 07:55 AM, Kenneth Shaw wrote: Hi All, usql is built in Go, and as of today supports all the major databases (PostgreSQL, MySQL, SQLite3, Microsoft SQL Server, Oracle Database) and more! Additionally, with v0.5.0, released today, usql now has implemented most of the basic, and much

[GENERAL] My humble tribute to psql -- usql v0.5.0

2017-04-02 Thread Kenneth Shaw
Hi All, I apologize in advance if this is somewhat off-topic, but I thought I would inform the people (ie, psql users) about usql, a universal-command line tool that aims to work the same way psql does, but with every database (not just PostgreSQL). usql is built in Go, and as of today supports a