Fails to parse passwords with '#' for mssql. about dburl HOT 9 CLOSED

Or even better: shouldn't dburl apply the URL escaping before splitting the DSN? That would solve the issue

from dburl.

You probably need to URL encode the # symbol then.

from dburl.

@kenshaw this should be in the Readme for usql and xo - Gotchas section. I have spend some hours yesterday trying to work around that issue with various escaping strategies... URL encoding did not occur to me! ))) thx, it seem to be connecting now. Query parsing for MSSQL seem to be still broken, but that is something else...

from dburl.

Ran into this issue too. Only worked out what to do from this issue, which took a while to find.

from dburl.

same issue. can we fix that, don't use net/url to parse.

from dburl.

if a fix isn't something you're interested in, then maybe just call it out in the README? i ran into this as well and it took a while to track down.

from dburl.

Could you suggest a change in the Readme in a pull request?

from dburl.

I understand the frustration, but this is the rules of URL parsing. Additionally, dburl is simply using Go's underlying net/url package, and is only wrapping some very minor / additional logic around net/url.URL. The idea/concept for dburl comes from a number of other database packages/libraries in other programming languages, and I believe all have the same issue when it comes to special characters in passwords.

from dburl.

Also, is this because you're using this with usql or somewhere else?

from dburl.