db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r159081 [2/2] - in incubator/derby/code/trunk/java/testing: ./ org/apache/derbyTesting/functionTests/harness/ org/apache/derbyTesting/functionTests/master/ org/apache/derbyTesting/functionTests/suites/ org/apache/derbyTesting/functionTests/tests/i18n/ org/apache/derbyTesting/functionTests/tests/i18n/data/
Date Sat, 26 Mar 2005 00:48:02 GMT
Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,97 @@
+ij> -- THIS TEST WILL NOT WORK WITH THE .jar files
+-- It uses a dummy message_qq_PP_testOnly.properties that exists
+-- only in the codeline
+--
+-- Message locale handling
+--
+--;
+-- load a fake driver that is really a piece of
+-- code that sets the default locale;
+driver 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale';
+ij> --
+-- create a databse in this default locale, should
+-- get english messages, as there are no messages
+-- for rr_TT;
+connect 'jdbc:derby:wombat;create=true';
+ij> -- make sure the database is clean
+drop procedure checkDefaultLoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'CHECKDEFAULTLOC' because it does not exist.
+ij> create procedure checkDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDefaultLocale';
+0 rows inserted/updated/deleted
+ij> drop procedure checkDatabaseLoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'CHECKDATABASELOC' because it does not exist.
+ij> create procedure checkDatabaseLoc(in locale char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> drop procedure setDefaultDELoc;
+ERROR 42Y55: 'DROP PROCEDURE' cannot be performed on 'SETDEFAULTDELOC' because it does not exist.
+ij> create procedure setDefaultLoc(in locale char(10), in code char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.setDefaultLocale';
+0 rows inserted/updated/deleted
+ij> drop table t1;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.
+ij> drop table t2;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.
+ij> call checkDefaultLoc();
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('rr_TT');
+0 rows inserted/updated/deleted
+ij> -- expect an error
+create table t1 oops (i int primary key);
+ERROR 42X01: Syntax error: Encountered "oops" at line 2, column 17.
+ij> -- setup for
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> -- expect a warning
+create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: The new index is a duplicate of an existing index: I2_A.
+ij> -- another error
+drop table t3;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T3' because it does not exist.
+ij> -- set the default locale to German;
+--call java.util.Locale::setDefault(new java.util.Locale('de', 'DE'));
+call setDefaultLoc('de','DE');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> -- create a database with a locale that has a small
+-- number of messages. Missing ones will default to
+-- the locale of the default locale i.e. German;
+connect 'jdbc:derby:testdb;create=true;territory=qq_PP_testOnly';
+ij> -- error (in qq_PP messages);
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+ERROR 42X01: Error of syntax: Encountered "oops" at line 3, column 17.
+ij> -- warning (in qq_PP messages);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: Der neue Index ist ein Duplikat eines vorhandenen Indexes: I2_A.
+ij> -- from default locale (German);
+drop table t3;
+ERROR 42Y55: 'DROP TABLE' kann nicht f EnC:>252< r 'T3' ausgef EnC:>252< hrt werden, da dieses Objekt nicht vorhanden ist.
+ij> -- should be in German;
+disconnect;
+ij> connect 'jdbc:derby:;shutdown=true';
+ERROR XJ015: Das Derby-System wird heruntergefahren.
+ij> -- Now, all Enlish messages;
+connect 'jdbc:derby:enTest;create=true;territory=en_US';
+ij> -- create table t1 (i longe);
+create table t1 oops (i int primary key);
+ERROR 42X01: Syntax error: Encountered "oops" at line 2, column 17.
+ij> -- create table t2 (i java.lang.Object);
+create table t2 (i int);
+0 rows inserted/updated/deleted
+ij> create index i2_a on t2(i);
+0 rows inserted/updated/deleted
+ij> create index i2_b on t2(i);
+0 rows inserted/updated/deleted
+WARNING 01504: The new index is a duplicate of an existing index: I2_A.
+ij> drop table t3;
+ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T3' because it does not exist.
+ij> disconnect;
+ij> 

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/messageLocale.out
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out Fri Mar 25 16:47:55 2005
@@ -0,0 +1,103 @@
+ij> --
+--
+-- URL locale handling
+--
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> create procedure checkRDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkRDefaultLocale';
+0 rows inserted/updated/deleted
+ij> -- this current database was created with the default locale
+call checkDatabaseLoc('en_US');
+0 rows inserted/updated/deleted
+ij> call checkRDefaultLoc();
+en_US
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> -- create a Swiss database
+connect 'jdbc:derby:swissdb;create=true;territory=fr_CH';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('fr_CH');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:swissdb;shutdown=true';
+ERROR 08006: Arr EnC:>234< t de la base de donn EnC:>233< es 'swissdb'.
+ij> -- check it is still Swiss when we re-boot
+connect 'jdbc:derby:swissdb';
+ij> call checkDatabaseLoc('fr_CH');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:swissdb;shutdown=true';
+ERROR 08006: Arr EnC:>234< t de la base de donn EnC:>233< es 'swissdb'.
+ij> -- Locale automatically converts the components to the correct case
+-- create a Hindi in India database (hi_IN)
+connect 'jdbc:derby:hindi;create=true;territory=HI_in';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('hi_IN');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:hindi;shutdown=true';
+ERROR 08006: Database 'hindi' shutdown.
+ij> -- now try one with a variant
+-- create a English in Israel database for JavaOS en_IL_JavaOS
+connect 'jdbc:derby:Israel;create=true;territory=en_IL_JavaOS';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('en_IL_JavaOS');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:Israel;shutdown=true';
+ERROR 08006: Database 'Israel' shutdown.
+ij> -- now try with just a language - we support this
+-- as some vms do.
+connect 'jdbc:derby:bacon;create=true;territory=da';
+ij> create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+0 rows inserted/updated/deleted
+ij> call checkDatabaseLoc('da');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:bacon;shutdown=true';
+ERROR 08006: Database 'bacon' shutdown.
+ij> connect 'jdbc:derby:bacon';
+ij> call checkDatabaseLoc('da');
+0 rows inserted/updated/deleted
+ij> disconnect;
+ij> connect 'jdbc:derby:bacon;shutdown=true';
+ERROR 08006: Database 'bacon' shutdown.
+ij> --
+-- some negative tests
+--
+connect 'jdbc:derby:fail1;create=true;territory=';
+ERROR XJ041: Failed to create database 'fail1', see the next exception for details.
+ERROR XBM0X: Supplied territory description '' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> -- database will not have been created so this connection will fail
+connect 'jdbc:derby:fail1;shutdown=true';
+ERROR XJ004: Database 'fail1' not found.
+ij> connect 'jdbc:derby:fail3;create=true;territory=en_';
+ERROR XJ041: Failed to create database 'fail3', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail4;create=true;territory=en_d';
+ERROR XJ041: Failed to create database 'fail4', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_d' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail5;create=true;territory=en_US_';
+ERROR XJ041: Failed to create database 'fail5', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en_US_' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> connect 'jdbc:derby:fail6;create=true;territory=en-US';
+ERROR XJ041: Failed to create database 'fail6', see the next exception for details.
+ERROR XBM0X: Supplied territory description 'en-US' is invalid, expecting ln[_CO[_variant]]
+ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
+ij> -- try using a database name with trailing blanks
+-- beetle 4653
+connect 'jdbc:derby:trailblank;create=true';
+ij> connect 'jdbc:derby:trailblank';
+ij(CONNECTION1)> connect 'jdbc:derby:trailblank     ';
+ij(CONNECTION2)> connect 'jdbc:derby:trailblank      ;shutdown=true';
+ERROR 08006: Database 'trailblank' shutdown.
+ij(CONNECTION2)> connect 'jdbc:derby:;shutdown=true';
+ERROR XJ015: Derby system shutdown.
+ij(CONNECTION2)> 

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/urlLocale.out
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties?view=diff&r1=159080&r2=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbyall.properties Fri Mar 25 16:47:55 2005
@@ -1,3 +1,3 @@
-suites=derbylang derbynetmats storeall xa derbytools jdbc20 jdk14 jdbcapi encryptionAll nist demo multi unit
+suites=derbylang derbynetmats storeall xa derbytools jdbc20 jdk14 jdbcapi encryptionAll nist demo multi unit i18nTest
 derby.debug.true=enableBtreeConsistencyCheck
 derby.stream.error.logSeverityLevel=0

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall Fri Mar 25 16:47:55 2005
@@ -0,0 +1,7 @@
+i18n/JapanCodeConversion.sql
+i18n/UnicodeEscape_JP.sql
+i18n/I18NImportExport.sql
+i18n/urlLocale.sql
+i18n/messageLocale.sql
+i18n/caseI_tr_TR.sql
+i18n/iepnegativetests_ES.sql

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/i18nTest.runall
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java Fri Mar 25 16:47:55 2005
@@ -0,0 +1,79 @@
+/*
+
+   Derby - Class org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale
+
+   Copyright 2000, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+   Licensed under the Apache License, Version 2.0 (the "License");
+   you may not use this file except in compliance with the License.
+   You may obtain a copy of the License at
+
+      http://www.apache.org/licenses/LICENSE-2.0
+
+   Unless required by applicable law or agreed to in writing, software
+   distributed under the License is distributed on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+   See the License for the specific language governing permissions and
+   limitations under the License.
+
+ */
+
+package org.apache.derbyTesting.functionTests.tests.i18n;
+
+import java.util.Locale;
+
+import java.sql.DriverManager;
+import java.sql.Connection;
+import java.sql.SQLException;
+
+public class DefaultLocale { 
+
+	static String savedLocale;
+
+	static {
+		savedLocale=java.util.Locale.getDefault().toString();
+		Locale.setDefault(new Locale("rr", "TT"));
+	}
+
+
+	// used in messageLocale test
+	public static void checkDefaultLocale() throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		String defLocale = java.util.Locale.getDefault().toString();
+		//System.out.println(defLocale);
+		if (!defLocale.equals("rr_TT"))
+			throw new SQLException("wrong_locale");
+	}
+
+	// used in urlLocale test
+	public static void checkRDefaultLocale() throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		System.out.println(savedLocale);
+		if (!savedLocale.equals("en_US"))
+			throw new SQLException("wrong_locale");
+	}
+
+	// used in messageLocale test
+	public static void checkDatabaseLocale(String Locale) throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		String dbLocale = org.apache.derby.iapi.db.Factory.getDatabaseOfConnection().getLocale().toString();
+		//System.out.println(dbLocale + "-");
+		//System.out.println(Locale + "-");
+		if (!dbLocale.toUpperCase().equals(Locale.toUpperCase().trim()))
+			throw new SQLException("wrong locale");
+	}
+
+	// used in messageLocale test
+	public static void setDefaultLocale(String Locale, String Code) throws SQLException
+	{
+		Connection conn = DriverManager.getConnection("jdbc:default:connection");
+		java.util.Locale.setDefault(new java.util.Locale(Locale.trim(),Code.trim()));
+	}
+
+
+
+
+}

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/DefaultLocale.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,32 @@
+drop table tab1;
+create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+insert into tab1 values(12.345, date('2000-05-25'),  'test row 1');
+insert into tab1 values(32.432, date('2000-01-14'),  'test row 2');
+insert into tab1 values(54.846, date('2000-08-21'),  'test row 3');
+insert into tab1 values(98.214, date('2000-12-08'),  'test row 4');
+insert into tab1 values(77.406, date('2000-10-19'),  'test row 5');
+insert into tab1 values(50.395, date('2000-11-29'),  'test row 6');
+
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8') ;
+
+-- localized display is off
+select * from tab1;
+
+LOCALIZEDDISPLAY ON;
+select * from tab1;
+
+drop table tab1;
+create table tab1( c1 decimal(5,3), c2 date, c3 char(20) );
+
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'tab1' , 'extinout/tab1_fr.unl' , 
+                                    null, null, 'UTF8', 0) ;
+
+
+-- localized display is off
+LOCALIZEDDISPLAY OFF;
+select * from tab1;
+
+LOCALIZEDDISPLAY ON;
+select * from tab1;
+

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,4 @@
+supportfiles=tests/i18n/data/Tab1_fr.ctrl,tests/i18n/data/Tab1_il.ctrl,tests/i18n/data/Tab1_jp.ctrl
+usedefaults=true
+derby.ui.locale=en_US
+useextdirs=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/I18NImportExport_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,26 @@
+drop table T1_EUC_JP;
+-- table for data in EUC_JP encoding
+create table T1_EUC_JP (	jnum int,
+				jtime time,
+				jstring char(200) );
+
+-- import data in EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_IMPORT_TABLE(null, 'T1_EUC_JP' ,
+	 		          'extin/jap_EUC_JP.dat' , 
+				  null, null, 'EUC_JP', 0) ;
+
+-- export to file with EUC_JP encoding 
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+	 		          'extinout/jap_EUC_JP.dump' , 
+				  null, null, 'EUC_JP') ;
+
+-- export to file with SJIS encoding	
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE('APP', 'T1_EUC_JP' ,
+	 		          'extinout/jap_SJIS.dump' , 
+				  null, null, 'SJIS') ;
+
+-- convert from EUC_JP to unicode with native2ascii
+! 'native2ascii -encoding EUC_JP extinout/jap_EUC_JP.dump';
+
+-- convert from SJIS to unicode with native2ascii
+! 'native2ascii -encoding SJIS extinout/jap_SJIS.dump';

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,4 @@
+runwithj9=false
+supportfiles=tests/i18n/data/jap_EUC_JP.dat,tests/i18n/data/jap_EUC_JP.ctrl,tests/i18n/data/jap_SJIS.ctrl
+usedefaults=true
+useextdirs=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/JapanCodeConversion_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,48 @@
+connect 'jdbc:derby:detest;create=true;' as Mnchen;
+
+drop table deta;
+create table detab ( dc1 decimal(5,3), dc3 date, dc2 char(200) );
+insert into detab values(1.123,date('2000-01-25'),'Zuviele Programme gefunden. Versuchen Sie es erneut.');
+insert into detab values(2.123,date('2000-02-24'),'Nur Teile der Entwicklungsdatenbank gefunden.');
+insert into detab values(3.123,date('2000-03-23'),'Mehr als eine Instanz der Tabelle %s in Entwicklungsdatenbank gefunden.');
+insert into detab values(4.123,date('2000-04-22'),'Mehr als einen Runner-Datensatz f?r dieses Programm gefunden.');
+insert into detab values(5.123,date('2000-05-21'),'Es kann nur eine BEFORE- oder AFTER INPUT/CONSTRUCT-Klausel in einer ');
+insert into detab values(6.123,date('2000-06-20'),'INPUT-/CONSTRUCT-Anweisung erscheinen.');
+insert into detab values(7.123,date('2000-07-19'),'Die Funktion %s kann nur in einer INPUT- oder CONSTRUCT-Anweisung ');
+insert into detab values(8.123,date('2000-08-18'),'Fglpc, der Pcode-Kompiler, ist nicht in Ihrem Pfad vorhanden.');
+insert into detab values(9.123,date('2000-09-17'),'Kann Runner %s nicht finden.');
+insert into detab values(10.123,date('2000-10-16'),'I/O-Fehler beim Laufen von fglc: %s.');
+insert into detab values(11.123,date('2000-11-15'),'I/O-Fehler beim Ausf?hren von fglc.');
+insert into detab values(12.123,date('2000-12-14'),'Kann Datei %s nicht ”ffnen, um den Wert einer TEXT-Variable zu lesen.');
+insert into detab values(13.123,date('2000-01-13'),'Der angegebene WORDWRAP RIGHT MARGIN-Wert liegt auáerhalb des Bereichs.'); 
+insert into detab values(14.123,date('2000-02-12'),'als oder gleich dem Wert des rechten Reportrands sein.');
+insert into detab values(15.123,date('2000-03-11'),'4GL unterst?tzt nicht die Ausgabe einer Blob-Variable.');
+insert into detab values(16.123,date('2000-04-10'),'Die HELP- und ATTRIBUTE-Klauseln k”nnen jeweils nur einmal definiert werden.');
+insert into detab values(17.123,date('2000-05-09'),'Ein Feld des INTERVAL-Kennzeichners liegt auáerhalb des Bereichs.'); 
+insert into detab values(18.123,date('2000-06-08'),'Der Bereich geht von YEAR TO MONTH und von DAY TO FRACTION.');
+insert into detab values(19.123,date('2000-07-07'),'Das Anlegen von Indizes ist hier nicht erlaubt.');
+insert into detab values(20.123,date('2000-08-06'),'Hier wird die Eingabe des Spaltennamen erwartet.');
+insert into detab values(21.123,date('2000-09-05'),'Hier wird die Eingabe des Tabellennamen erwartet.');
+insert into detab values(22.123,date('2000-10-04'),'Der eigentliche Spaltenname kann hier nicht angegeben werden.'); 
+insert into detab values(23.123,date('2000-11-03'),'Die maximale Gr”áe f?r Varchar muá zwischen 1 und 255 liegen.');
+insert into detab values(24.123,date('2000-12-02'),'Kann keine tempor„re Datei %s anlegen, um eine Blob-Variable aufzunehmen.');
+insert into detab values(25.123,date('2000-11-01'),'Symbol %s muá ein SQL-Datenbank-Elementname sein - entweder ein ');
+insert into detab values(26.123,date('2000-10-28'),'Datenbankname, ein Tabellenname oder ein Spaltenname.');
+insert into detab values(27.123,date('2000-09-29'),'DATETIME-Einheiten k”nnen nur YEAR, MONTH, DAY, HOUR, MINUTE,'); 
+insert into detab values(28.123,date('2000-08-30'),'Eingeklammerte Genauigkeit von FRACTION muá zwischen 1 und 5 liegen.');
+insert into detab values(29.123,date('2000-07-31'),'F?r andere Zeiteinheiten kann keine Genauigkeit definiert werden.');
+insert into detab values(30.123,date('2000-06-25'),'Das Startfeld von DATETIME oder INTERVAL-Kennzeichnern muá in der ');
+insert into detab values(31.123,date('2000-05-25'),'Zeitliste vor dem Endfeld stehen.');
+insert into detab values(32.123,date('2000-04-25'),'Entladen in Datei %s miálungen.');
+insert into detab values(33.123,date('2000-03-25'),'Laden aus Datei %s miálungen.');
+insert into detab values(34.123,date('2000-02-25'),'Das Programm kann eine DISPLAY ARRAY-Anweisung an dieser Stelle nicht'); 
+insert into detab values(35.123,date('2000-01-25'),'beenden, weil es sich nicht in einer DISPLAY ARRAY-Anweisung befindet.');
+insert into detab values(36.123,date('2000-02-25'),'Das Programm kann eine INPUT-Anweisung an dieser Stelle nicht beenden,'); 
+insert into detab values(37.123,date('2000-04-25'),'weil es sich nicht in einer INPUT-Anweisung befindet.');
+insert into detab values(38.123,date('2000-05-25'),'Konnte Datei %s nicht ”ffnen.');
+insert into detab values(39.123,date('2000-07-25'),'Name des Eigent?mers %s hat die L„nge von 8 Zeichen ?berschritten.');
+insert into detab values(40.123,date('2000-09-25'),'Fehler bei der Speicherzuordnung.');
+insert into detab values(41.123,date('2000-05-25'),'Unter dem angegebenen Namen wurde kein lauff„higes 4GL-Programm gefunden.');
+LOCALIZEDDISPLAY ON;
+show connections;
+select * from detab;

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,3 @@
+usedefaults=true
+derby.ui.codeset=Cp850
+derby.ui.locale=de_DE

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedConnectionAttribute_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,28 @@
+drop table localtab;
+create table localtab(	ndec decimal(5,3), 
+							ndatec date , 
+							ntimec time , 
+							ncharc varchar(500));
+insert into localtab values(12.345, date('2000-05-25'),'15:30:15','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
+insert into localtab values(32.432, date('2000-05-18'),'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+insert into localtab values(54.846, date('2000-01-28'),'15:32:28','INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into localtab values(39.003, date('2000-11-11'),'15:32:29','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f');
+insert into localtab values(79.406, date('2000-06-05'),'15:32:29','\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002');
+insert into localtab values(94.999, date('2000-07-30'),'15:32:30','On-Line\u30e2\u30fc\u30c9');
+insert into localtab values(18.849, date('2000-10-22'),'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
+insert into localtab values(35.444, date('2000-02-29'),'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into localtab values(84.391, date('2000-01-21'),'15:33:23','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into localtab values(56.664, date('2000-04-16'),'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into localtab values(22.393, date('2000-03-01'),'15:33;42','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into localtab values(90.007, date('2000-11-27'),'15:33:43','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f');
+insert into localtab values(30.496, date('2000-04-03'),'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into localtab values(66.295, date('2000-10-15'),'15:34:30','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into localtab values(54.332, date('2000-09-01'),'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into localtab values(11.105, date('2000-07-09'),'15:39:10','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79d2\u3067\u3057\u305f');
+
+-- display in non localized format
+select * from localtab;
+
+-- display in localized format
+LOCALIZEDDISPLAY ON;
+select * from localtab;

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,4 @@
+usedefaults=true
+ij.unicodeEscape=on
+derby.ui.locale=es_AR
+derby.ui.codeset=EUC_JP

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/LocalizedDisplay_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,22 @@
+drop table jtest;
+create table jtest(jint integer, jtime time, jvarchar varchar(255));
+UNICODEESCAPE ON;
+insert into jtest values(1,'15:32:06','\u30a4\u30d9\u30f3\u30c8\u30a2\u30e9\u30fc\u30e0\u304c\u6709\u52b9\u3067\u3059\u3002');
+insert into jtest values(2,'15:32:10','DR:DRAUTO\u306f0 (Off)\u3067\u3059\u3002');
+insert into jtest values(3,'15:32:28','INFORMIX-OnLine\u304c\u521d\u671f\u5316\u3055\u308c\u3001\u30c7\u30a3\u30b9\u30af\u306e\u521d\u671f\u5316\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(4,'15:32:29','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 0\u79d2\u3067\u3057\u305f');
+insert into jtest values(5,'15:32:29','\u3059\u3079\u3066\u306eDB\u9818\u57df\u306e\u30c7\u30fc\u30bf\u30b9\u30ad\u30c3\u30d7\u306f\u73fe\u5728\u30aa\u30d5\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002');
+insert into jtest values(6,'15:32:30','On-Line\u30e2\u30fc\u30c9');
+insert into jtest values(7,'15:32:31','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u4e2d\u3067\u3059...');
+insert into jtest values(8,'15:33:22','\u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(9,'15:33:23','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 1\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into jtest values(10,'15:33:40','\u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(11,'15:33:41','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 2\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into jtest values(12,'15:33:43','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 2\u79d2\u3067\u3057\u305f');
+insert into jtest values(13,'15:34:29','\u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(14,'15:34:30','\u30ea\u30bf\u30fc\u30f3\u30b3\u30fc\u30c9 1\u3092\u623b\u3057\u3066\u30d7\u30ed\u30bb\u30b9\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 \u8ad6\u7406\u30ed\u30b0 3\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002 \u8ad6\u7406');
+insert into jtest values(15,'15:35:35','sysmaster\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u306f\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002');
+insert into jtest values(16,'15:39:10','\u30c1\u30a7\u30c3\u30af\u30dd\u30a4\u30f3\u30c8\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f:\u7d99\u7d9a\u6642\u9593\u306f 8\u79d2\u3067\u3057\u305f');
+select * from jtest;
+call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('APP', 'jtest' , 'extout/jtest.unl' , 
+                                    null, null,'EUC_JP') ;

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,4 @@
+supportfiles=tests/i18n/data/jap_EUC_JP.ctrl
+usedefaults=true
+derby.ui.codeset=EUC_JP
+useextdirs=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/UnicodeEscape_JP_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml Fri Mar 25 16:47:55 2005
@@ -0,0 +1,90 @@
+<?xml version="1.0"?>
+
+<!-- ==================================================================== -->
+<!--                       Derby build file                          -->
+<!-- ==================================================================== -->
+
+<project default="FTOtestsubdir" basedir="../../../../../../../.." >
+
+<!-- ==================================================================== -->
+<!--                           Set properties                             -->
+<!-- ==================================================================== -->
+
+  <!-- User settings -->
+  <property file="${user.home}/ant.properties"/>
+
+  <!-- Set property lib dir -->
+  <property name="properties.dir" value="tools/ant/properties" />
+
+  <!-- Significant dirs -->
+  <property file="${properties.dir}/dirs.properties"/>
+  <property file="${properties.dir}/derbytesting.properties"/>
+
+  <!-- Compiler settings -->
+  <property file="${properties.dir}/sane${sanity}.properties"/>
+  <property file="${properties.dir}/defaultcompiler.properties"/>
+  <property file="${properties.dir}/${build.compiler}.properties"/>
+
+  <!-- Parser properties -->
+  <!--property file="${properties.dir}/parser.properties"/-->
+
+  <!-- Compile-time classpath properties files -->
+  <property file="${properties.dir}/extrapath.properties"/>
+  <property file="${properties.dir}/compilepath.properties"/>
+
+  <!-- Release and Version info -->
+  <property file="${properties.dir}/release.properties"/>
+
+  <!-- derby testing specific properties files -->
+  <property file="${ant.home}/properties/derbytesting.properties"/>
+  <property file="${user.home}/properties/derbytesting.properties"/>
+  <property name="this.dir" value="${derby.testing.functest.dir}/tests/i18n"/>
+
+<!--             ============ Begin Targets ==============                -->
+ 
+  <target name="FTOtestsubdir" depends="compile,copyfiles"/>
+
+  <!-- mkdir / init target should not be necessary, just here for reference... -->
+  <target name="init">
+    <mkdir dir="${out.dir}/${derby.testing.functest.dir}/tests/i18n"/>
+  </target>
+
+  <target name="compile">
+    <javac
+      bootclasspath="${empty}"
+      nowarn="on"
+      debug="${debug}"
+      depend="${depend}"
+      deprecation="${deprecation}"
+      optimize="${optimize}"
+      proceed="${proceed}"
+      verbose="${verbose}" 
+      srcdir="${derby.testing.src.dir}"
+      destdir="${out.dir}">
+      <classpath>
+        <!--pathelement location="${oro}"/-->
+        <pathelement path="${compile.classpath}"/>
+      </classpath>
+      <include name="${this.dir}/*.java"/>
+    </javac>
+  </target>
+
+
+  <target name="copyfiles">
+    <copy todir="${out.dir}/${derby.testing.functest.dir}/tests/i18n">
+      <fileset dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n" 
+        includesfile="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/copyfiles.ant"/>  
+    </copy>
+    <copy todir="${out.dir}/${derby.testing.functest.dir}/tests/i18n/data">
+      <fileset dir="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/data" 
+        includesfile="${derby.testing.src.dir}/${derby.testing.functest.dir}/tests/i18n/data/copyfiles.ant"/>  
+    </copy>
+  </target> 
+
+
+<!--             ============= End Targets ==============                -->
+
+<!--             ============= End Project ==============                -->
+
+</project>
+

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/build.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,9 @@
+create function FMTUNICODE(P1 VARCHAR(100)) RETURNS VARCHAR(300)
+EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.format'
+NO SQL
+LANGUAGE JAVA PARAMETER STYLE JAVA;
+
+ values FMTUNICODE(UCASE('i'));
+ values FMTUNICODE(UCASE('I'));
+ values FMTUNICODE(LCASE('i'));
+ values FMTUNICODE(LCASE('I'));

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1 @@
+database=jdbc:derby:trdb;create=true;territory=tr_TR

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/caseI_tr_TR_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant Fri Mar 25 16:47:55 2005
@@ -0,0 +1,19 @@
+I18NImportExport.sql
+I18NImportExport_app.properties
+JapanCodeConversion.sql
+JapanCodeConversion_app.properties
+LocalizedConnectionAttribute.sql
+LocalizedConnectionAttribute_app.properties
+LocalizedDisplay.sql
+LocalizedDisplay_app.properties
+UnicodeEscape_JP.sql
+UnicodeEscape_JP_app.properties
+caseI_tr_TR.sql
+caseI_tr_TR_app.properties
+default_app.properties
+default_derby.properties
+iepnegativetests_ES.sql
+iepnegativetests_ES_app.properties
+messageLocale.sql
+messageLocale_app.properties
+urlLocale.sql

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/copyfiles.ant
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl Fri Mar 25 16:47:55 2005
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=fr_FR
+FieldEndDelimiter="

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_fr.ctrl
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl Fri Mar 25 16:47:55 2005
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=iw_IL
+FieldEndDelimiter="

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_il.ctrl
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl Fri Mar 25 16:47:55 2005
@@ -0,0 +1,12 @@
+#Import/Export Properties
+#Wed Feb 23 15:51:10 GMT+02:00 2000
+ColumnDefinition=True
+DataCodeset=UTF8
+Format=ASCII_DELIMITED
+RecordSeparator=CR-LF
+Null=NULL
+Version=1
+FieldStartDelimiter="
+FieldSeparator=Comma
+DataLocale=ja_JP
+FieldEndDelimiter="

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/Tab1_jp.ctrl
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant Fri Mar 25 16:47:55 2005
@@ -0,0 +1,6 @@
+Tab1_fr.ctrl
+Tab1_il.ctrl
+Tab1_jp.ctrl
+jap_EUC_JP.ctrl
+jap_EUC_JP.dat
+jap_SJIS.ctrl

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/copyfiles.ant
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl Fri Mar 25 16:47:55 2005
@@ -0,0 +1,7 @@
+#Import/Export Properties
+#Wed Oct 21 13:18:48 PDT 1998
+DataCodeset=EUC_JP
+RecordSeparator=CR-LF
+FieldStartDelimiter="
+FieldSeparator=Comma
+FieldEndDelimiter="

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.ctrl
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_EUC_JP.dat Fri Mar 25 16:47:55 2005
@@ -0,0 +1,16 @@
+"1","15:32:06","¥¤¥Ù¥ó¥È¥¢¥é¡¼¥à¤¬Í­¸ú¤Ç¤¹¡£"
+"2","15:32:10","DR:DRAUTO¤Ï0 (Off)¤Ç¤¹¡£"
+"3","15:32:28","INFORMIX-OnLine¤¬½é´ü²½¤µ¤ì¡¢¥Ç¥£¥¹¥¯¤Î½é´ü²½¤¬´°Î»¤·¤Þ¤·¤¿¡£"
+"4","15:32:29","¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 0ÉäǤ·¤¿"
+"5","15:32:29","¤¹¤Ù¤Æ¤ÎDBÎΰè¤Î¥Ç¡¼¥¿¥¹¥­¥Ã¥×¤Ï¸½ºß¥ª¥Õ¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£"
+"6","15:32:30","On-Line¥â¡¼¥É"
+"7","15:32:31","sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®Ãæ¤Ç¤¹..."
+"8","15:33:22","ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£"
+"9","15:33:23","¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 1¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý"
+"10","15:33:40","ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£"
+"11","15:33:41","¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 2¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý"
+"12","15:33:43","¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 2ÉäǤ·¤¿"
+"13","15:34:29","ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£"
+"14","15:34:30","¥ê¥¿¡¼¥ó¥³¡¼¥É 1¤òÌᤷ¤Æ¥×¥í¥»¥¹¤¬½ªÎ»¤·¤Þ¤·¤¿:/bin/sh /bin/sh -c /work1/MOSES_7.22.UC1A5_27/sqldist/etc/log_full.sh 2 23 ÏÀÍý¥í¥° 3¤¬´°Î»¤·¤Þ¤·¤¿¡£ ÏÀÍý"
+"15","15:35:35","sysmaster¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎºîÀ®¤Ï´°Î»¤·¤Þ¤·¤¿¡£"
+"16","15:39:10","¥Á¥§¥Ã¥¯¥Ý¥¤¥ó¥È¤¬´°Î»¤·¤Þ¤·¤¿:·Ñ³»þ´Ö¤Ï 8ÉäǤ·¤¿"

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl Fri Mar 25 16:47:55 2005
@@ -0,0 +1,7 @@
+#Import/Export Properties
+#Wed Oct 21 13:18:48 PDT 1998
+DataCodeset=SJIS
+RecordSeparator=CR-LF
+FieldStartDelimiter="
+FieldSeparator=Comma
+FieldEndDelimiter="

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/data/jap_SJIS.ctrl
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,24 @@
+#
+# This is the default system properties file for SQL and JAVA tests.
+#
+# *** DO NOT PUT PROPERTIES FOR THE DERBY SYSTEM IN THIS FILE.  
+# *** THEY BELONG IN default_derby.properties.
+#
+# This file will get handed to the test on the command line in a -p <filename>
+# argument.
+#
+# This causes ij to load the driver and make an
+# initial connection to the database.
+#
+# The .java test has to call util.getPropertyArg and util.startJBMS
+# to process the property file.  See any of the .java tests for this code.
+#
+# If you want to alter these to use a different driver, connect to a different
+# database, or to not be used, override this file by creating
+# a file <testname>_app.properties to be used instead of this file.
+#
+database=jdbc:derby:wombat;create=true
+derby.optimizer.noTimeout=true
+
+ij.showNoConnectionsAtStart=true
+ij.showNoCountForSelect=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,7 @@
+# statement cache size of 20 is the default, do not add this property
+# to this file.  If your test wants to do consistency checking that
+# requires an empty cache, add a special .properties file, see
+# inbetween.properties for an example.
+#
+# derby.language.statementCacheSize=20
+derby.infolog.append=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/default_derby.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,2 @@
+--run the import/export negative tests in locale ES 
+run resource  '/org/apache/derbyTesting/functionTests/tests/tools/iepnegativetests.sql';

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,2 @@
+database=jdbc:derby:wombat;create=true;territory=es_MX;unicode=true
+useextdirs=true

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/iepnegativetests_ES_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,81 @@
+-- THIS TEST WILL NOT WORK WITH THE .jar files
+-- It uses a dummy message_qq_PP_testOnly.properties that exists
+-- only in the codeline
+--
+-- Message locale handling
+--
+--;
+
+-- load a fake driver that is really a piece of
+-- code that sets the default locale;
+driver 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale';
+
+--
+-- create a databse in this default locale, should
+-- get english messages, as there are no messages
+-- for rr_TT;
+connect 'jdbc:derby:wombat;create=true';
+
+-- make sure the database is clean
+drop procedure checkDefaultLoc;
+create procedure checkDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDefaultLocale';
+drop procedure checkDatabaseLoc;
+create procedure checkDatabaseLoc(in locale char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+drop procedure setDefaultDELoc;
+create procedure setDefaultLoc(in locale char(10), in code char(10)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.setDefaultLocale';
+drop table t1;
+drop table t2;
+
+call checkDefaultLoc();
+call checkDatabaseLoc('rr_TT');
+
+-- expect an error
+create table t1 oops (i int primary key);
+-- setup for
+create table t2 (i int);
+create index i2_a on t2(i);
+-- expect a warning
+create index i2_b on t2(i);
+-- another error
+drop table t3;
+
+-- set the default locale to German;
+--call java.util.Locale::setDefault(new java.util.Locale('de', 'DE'));
+call setDefaultLoc('de','DE');
+
+disconnect;
+
+-- create a database with a locale that has a small
+-- number of messages. Missing ones will default to
+-- the locale of the default locale i.e. German;
+connect 'jdbc:derby:testdb;create=true;territory=qq_PP_testOnly';
+
+-- error (in qq_PP messages);
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+
+-- warning (in qq_PP messages);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+create index i2_a on t2(i);
+create index i2_b on t2(i);
+
+-- from default locale (German);
+drop table t3;
+
+-- should be in German;
+disconnect;
+connect 'jdbc:derby:;shutdown=true';
+
+-- Now, all Enlish messages;
+connect 'jdbc:derby:enTest;create=true;territory=en_US';
+
+-- create table t1 (i longe);
+create table t1 oops (i int primary key);
+-- create table t2 (i java.lang.Object);
+create table t2 (i int);
+create index i2_a on t2(i);
+create index i2_b on t2(i);
+drop table t3;
+disconnect;
+

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale.sql
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties Fri Mar 25 16:47:55 2005
@@ -0,0 +1,3 @@
+#
+# No default driver or connection
+fake=ij seems to need one property set

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/messageLocale_app.properties
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql?view=auto&rev=159081
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql Fri Mar 25 16:47:55 2005
@@ -0,0 +1,78 @@
+--
+--
+-- URL locale handling
+--
+
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+create procedure checkRDefaultLoc() parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkRDefaultLocale';
+-- this current database was created with the default locale
+call checkDatabaseLoc('en_US');
+call checkRDefaultLoc();
+
+disconnect;
+
+-- create a Swiss database
+connect 'jdbc:derby:swissdb;create=true;territory=fr_CH';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('fr_CH');
+disconnect;
+connect 'jdbc:derby:swissdb;shutdown=true';
+
+-- check it is still Swiss when we re-boot
+connect 'jdbc:derby:swissdb';
+call checkDatabaseLoc('fr_CH');
+disconnect;
+connect 'jdbc:derby:swissdb;shutdown=true';
+
+
+-- Locale automatically converts the components to the correct case
+-- create a Hindi in India database (hi_IN)
+connect 'jdbc:derby:hindi;create=true;territory=HI_in';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('hi_IN');
+disconnect;
+connect 'jdbc:derby:hindi;shutdown=true';
+
+
+-- now try one with a variant
+-- create a English in Israel database for JavaOS en_IL_JavaOS
+connect 'jdbc:derby:Israel;create=true;territory=en_IL_JavaOS';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('en_IL_JavaOS');
+disconnect;
+connect 'jdbc:derby:Israel;shutdown=true';
+
+-- now try with just a language - we support this
+-- as some vms do.
+connect 'jdbc:derby:bacon;create=true;territory=da';
+create procedure checkDatabaseLoc(in locale char(12)) parameter style java language java external name 'org.apache.derbyTesting.functionTests.tests.i18n.DefaultLocale.checkDatabaseLocale';
+call checkDatabaseLoc('da');
+disconnect;
+connect 'jdbc:derby:bacon;shutdown=true';
+connect 'jdbc:derby:bacon';
+call checkDatabaseLoc('da');
+disconnect;
+connect 'jdbc:derby:bacon;shutdown=true';
+
+
+--
+-- some negative tests
+--
+connect 'jdbc:derby:fail1;create=true;territory=';
+-- database will not have been created so this connection will fail
+connect 'jdbc:derby:fail1;shutdown=true';
+
+connect 'jdbc:derby:fail3;create=true;territory=en_';
+connect 'jdbc:derby:fail4;create=true;territory=en_d';
+connect 'jdbc:derby:fail5;create=true;territory=en_US_';
+connect 'jdbc:derby:fail6;create=true;territory=en-US';
+
+-- try using a database name with trailing blanks
+-- beetle 4653
+connect 'jdbc:derby:trailblank;create=true';
+connect 'jdbc:derby:trailblank';
+connect 'jdbc:derby:trailblank     ';
+connect 'jdbc:derby:trailblank      ;shutdown=true';
+
+
+connect 'jdbc:derby:;shutdown=true';

Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/i18n/urlLocale.sql
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message