Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL formatting problem if using \ character in file #3862

Closed
ertankucukoglu opened this issue Oct 30, 2017 · 1 comment
Closed

SQL formatting problem if using \ character in file #3862

ertankucukoglu opened this issue Oct 30, 2017 · 1 comment

Comments

@ertankucukoglu
Copy link

Hello,

I seem to hit some formatting problem with SQL files. If there is "" character in a quoted text it seems to be used as some other means. For better understanding, please use below text in any file with .sql extension.

insert into params(paramname, valuetxt) values('KeyboardKey_47', '.');
insert into params(paramname, valuetxt) values('KeyboardKey_48', '>');
insert into params(paramname, valuetxt) values('KeyboardKey_49', '_');
insert into params(paramname, valuetxt) values('KeyboardKey_50', '/');
insert into params(paramname, valuetxt) values('KeyboardKey_51', '\');
insert into params(paramname, valuetxt) values('KeyboardKey_52', '[');
insert into params(paramname, valuetxt) values('KeyboardKey_53', ']');
insert into params(paramname, valuetxt) values('KeyboardKey_54', '(');
insert into params(paramname, valuetxt) values('KeyboardKey_55', ')');
insert into params(paramname, valuetxt) values('KeyboardKey_56', '%');

You should have a formatting change starting with line having "KeyboardKey_51".
My screen look like: http://i65.tinypic.com/350j97m.png
Version I am using is: 7.5.1 (32bits) on Windows 10 64bit OS.
Build time: Aug 29 2017 - 02:35:41

@dail8859
Copy link
Contributor

dail8859 commented Nov 1, 2017

Settings > Preferences > MISC. > Treat backslash as escape character for SQL

Duplicate of #3816, #3187, #2451 and probably others.
capture

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants