java - how can i get correct Collation by sql query or other way of Sqlserver -

-

i can collation below query:

select name, description sys.fn_helpcollations();  albanian_bin albanian_bin2 albanian_ci_ai albanian_ci_ai_ws albanian_ci_ai_ks albanian_ci_ai_ks_ws albanian_ci_as albanian_ci_as_ws albanian_ci_as_ks albanian_ci_as_ks_ws albanian_cs_ai albanian_cs_ai_ws albanian_cs_ai_ks albanian_cs_ai_ks_ws albanian_cs_as albanian_cs_as_ws albanian_cs_as_ks albanian_cs_as_ks_ws albanian_100_bin albanian_100_bin2 albanian_100_ci_ai albanian_100_ci_ai_ws albanian_100_ci_ai_ks albanian_100_ci_ai_ks_ws albanian_100_ci_as albanian_100_ci_as_ws albanian_100_ci_as_ks albanian_100_ci_as_ks_ws albanian_100_cs_ai albanian_100_cs_ai_ws albanian_100_cs_ai_ks albanian_100_cs_ai_ks_ws albanian_100_cs_as albanian_100_cs_as_ws albanian_100_cs_as_ks albanian_100_cs_as_ks_ws albanian_100_ci_ai_sc albanian_100_ci_ai_ws_sc albanian_100_ci_ai_ks_sc albanian_100_ci_ai_ks_ws_sc albanian_100_ci_as_sc albanian_100_ci_as_ws_sc albanian_100_ci_as_ks_sc albanian_100_ci_as_ks_ws_sc albanian_100_cs_ai_sc albanian_100_cs_ai_ws_sc albanian_100_cs_ai_ks_sc albanian_100_cs_ai_ks_ws_sc albanian_100_cs_as_sc albanian_100_cs_as_ws_sc albanian_100_cs_as_ks_sc albanian_100_cs_as_ks_ws_sc arabic_bin arabic_bin2 arabic_ci_ai arabic_ci_ai_ws arabic_ci_ai_ks arabic_ci_ai_ks_ws arabic_ci_as ...

i found there more 1 collation per each locale

when setup sqlserver, sqlserver can select default collation follow current os's locale.

so, want know collation used default.

for example, current locale that:

system.out.println(locale.getdefault().getdisplaycountry()); system.out.println(locale.getdefault().getdisplaylanguage()); system.out.println(locale.getdefault().getdisplayname()); system.out.println(locale.getdefault().getlanguage());

output:

united states english english (united states) en

now, during sqlserver installation, use "sql_latin1_general_cp1_ci_as" automatically, how sqlserver know it, mapping list?

i want default collation api or query sql sqlserver collation when installation.

assume can os locale info, how related default collation java api or windows native api or query db or way?


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

python - pip wont install .WHL files -

-
when try install .whl gohike typing cmd c:\users\owner\downloads>pip install ta_lib-0.4.9-cp27-none-win_amd64.whl i print out: `processing c:\users\owner\downloads\ta_lib-0.4.9-cp27-none-win_amd64.whl complete output command python setup.py egg_info: traceback <most recent call last>: file "<string>", line 1, in <module> ioerror: [errno 2] no such file or directory:'c:\\users\\owner\\appdata\\lo cal\\temp\\pip-9gwk2c-build\\setup.py' ----------------------------------------- command "python setup.py egg_info" failed error code 1 in c:\users\owner\ap pdata\local\temp\pip-9gwk2c-build\` the part between pip- , -build in pip-9gwk2c-build different on same file. i asked python 2.7.11 pip 8.0.3 can't install gohike whl of ta-lib 0.4.9 few days ago , decided ask differently. can me! you have outdated pip not understand wheels. wheels not supposed have setup.py inside. try upgrading pip pip in...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more