[jira] [Closed] (DERBY-4508) ij on slavic machine does not create files with appropriate encoding

["Myrna van Lunteren (Closed) (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren closed DERBY-4508.
-------------------------------------

    Resolution: Won't Fix

I believe the user that ran into this has implemented a work-around (using another script than ij and passing in the encoding values required).
A problem I had noted from my tests is that the behavior was different when running with IBM jvms vs. Sun (at the time) jvms - with the IBM jvms it was necessary to set -Dfile.encoding, so there may be a jvm incompatibility issue here too which would make a solution that always works complicated.
I'm now closing this as won't fix.

                
> ij on slavic machine does not create files with appropriate encoding
> --------------------------------------------------------------------
>
>                 Key: DERBY-4508
>                 URL: https://issues.apache.org/jira/browse/DERBY-4508
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects Versions: 10.5.3.0
>         Environment: PC (windows Server 2007) with codepage Cp852 (console.encoding is Cp852)
>            Reporter: Myrna van Lunteren
>         Attachments: GarbledFilename.java
>
>
> On a machine configured with slavic codeset Cp852 ij does not always create (or access) files with appropriate characters.
> For instance, consider the following string with non-ascii characters: Českýnázev
> When starting ij using only defaults: java org.apache.derby.tools.ij (or using one of the ij scripts from bin) and issueing the following connect statement:
>    ij> connect 'jdbc:derby:Českýnázev;create=true';
> ij creates a database that on the OS shows like so: ¬eskěn zev
> When I have a file - e.g. simple.sql - that does this connect, the file created on the OS has the expected name (Českýnázev).
> Using a simple program that does the same as org.apache.derby.iapi.tools.i18n.LocalizedInput
> (only 1 method, main), with appropriate  imports):
> -----------------------
>     public static void main(String[] args) throws Exception {
>         InputStreamReader isr = new InputStreamReader(System.in);
>         BufferedReader in = new BufferedReader(isr);
>         String inputString = in.readLine();
>         System.out.println("inputString: " + inputString);
>         
>         File f = new File(inputString);
>         f.createNewFile();
>         System.out.println("created a file called " + inputString);
>         
>         in.close();
>         isr.close();
>     }
> ----------------------------------------
> Sun's jdk 1.6 gives the following output:
> ------------------
> Českýnázev
> inputString: Českýnázev
> created a file called Českýnázev
> ------------------
> While IBM's jdk 1.6 does this:
> ------------------
> Českýnázev
> inputString: ¬eskěn zev
> created a file called ¬eskěn zev
> ------------------
> However in both cases the file created on the OS (dos prompt, windows explorer) looks like the way ij created the database dir:
> ¬eskěn zev
> If we specify -Dfile.encoding=Cp852, or -Dderby.ui.codeset=Cp852 when starting ij, the file created has the expected name, so this is a workaround.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira