[BUGS] Swedish characters

[Rickard Annell]

 POSTGRESQL BUG REPORT TEMPLATE



Your name   :   Rickard Annell
Your email address  :   [EMAIL PROTECTED]


System Configuration
-
   Architecture (example: Intel Pentium) :  PowerPC 604e

   Operating System (example: Linux 2.0.26 ELF)  :  AIX v 4.3.3

   PostgreSQL version (example: PostgreSQL-7.1):   PostgreSQL-7.1beta5

   Compiler used (example:  gcc 2.8.0)   :  gcc v. 2.95.2


Please enter a FULL description of your problem:

Problem with match swedish characters in SQL query.





Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
--

./configure  --prefix=/service/database/postgres_test --enable-odbc 
--enable-local
export LC_ALL=sv_SE
export LC_CTYPE=sv_SE
export LC_COLLATE=sv_SE

nohup ./postmaster -p 5431 -i >server.log 2>&1 &
./createdb -p 5431 cybertest
./psql -p 5431 cybertest
create table test (id int , name varchar,primary key(id));
insert into test values (1,'Åsbrink');
select * from test where lower(name) like '%å%';
  id | name
+--
(0 rows)

I think "lower(name) like '%å%'" should match. If i try "lower(name) 
like '%Å%'" I get one row.




If you know how this problem might be fixed, list the solution below:
-

-- 
_______
Rickard Annell  E-mail: [EMAIL PROTECTED]
SYSteam UdacWWW: http://www.udac.se
Tel: +46 (0)18 4717700
Box 174, S-751 04 Uppsala, Sweden   Fax: +46 (0)18 516600

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[BUGS] Compile problem postgresql-7.3rc1 and Mac OS X 10.2.2

[Rickard Annell]

system info:
Mac OS X v 10.2.2 (Darwin Kernel Version 6.2: Tue Nov  5 22:00:03 PST 
2002; root:xnu/xnu-344.12.2.obj~1/RELEASE_PPC)
Java build 1.3.1_03-69, mixed mode
Ant version 1.5
gcc  Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 
20020420 (prerelease)
postgres 7.3rc1



./configure --prefix=/service/database/postgres --with-java

make


last rows from make command


make[5]: Nothing to be done for `all'.
/service/www/jakarta/ant/bin/ant -buildfile ./build.xml all \
  -Dmajor=7 -Dminor=3 -Dfullversion=7.3rc1 -Ddef_pgport=5432 -Denable_debug=no
Buildfile: ./build.xml

all:

prepare:

check_versions:

driver:
 [copy] Copying 1 file to 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql
 [echo] Configured build for the JDBC2 edition driver

compile:
[javac] Compiling 25 source files to 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/build
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:240: 
cannot resolve symbol
[javac] symbol  : constructor Array 
(org.postgresql.PGConnection,int,org.postgresql.Field,java.sql.ResultSet)
[javac] location: class org.postgresql.jdbc2.Array
[javac] return (java.sql.Array) new 
org.postgresql.jdbc2.Array( connection, i, fields[i - 1], 
(java.sql.ResultSet) this );
[javac] ^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:420: 
incompatible types
[javac] found   : java.sql.Statement
[javac] required: org.postgresql.jdbc2.Statement
[javac] return statement;
[javac]^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:560: 
incompatible types
[javac] found   : java.sql.PreparedStatement
[javac] required: org.postgresql.jdbc2.PreparedStatement
[javac] deleteStatement = 
((java.sql.Connection) 
connection).prepareStatement(deleteSQL.toString());
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:619: 
incompatible types
[javac] found   : java.sql.PreparedStatement
[javac] required: org.postgresql.jdbc2.PreparedStatement
[javac] insertStatement = 
((java.sql.Connection) 
connection).prepareStatement(insertSQL.toString());
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:639: 
inconvertible types
[javac] found   : org.postgresql.jdbc2.PreparedStatement
[javac] required: org.postgresql.jdbc2.AbstractJdbc2Statement
[javac] long insertedOID = 
((AbstractJdbc2Statement) insertStatement).getLastOID();
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:955: 
incompatible types
[javac] found   : java.sql.PreparedStatement
[javac] required: org.postgresql.jdbc2.PreparedStatement
[javac] selectStatement = 
((java.sql.Connection) 
connection).prepareStatement(selectSQL.toString());
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java:1038: 
incompatible types
[javac] found   : java.sql.PreparedStatement
[javac] required: org.postgresql.jdbc2.PreparedStatement
[javac] updateStatement = 
((java.sql.Connection) 
connection).prepareStatement(updateSQL.toString());
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java:51: 
inconvertible types
[javac] found   : org.postgresql.jdbc2.AbstractJdbc2Statement
[javac] required: org.postgresql.jdbc2.Statement
[javac] 
((AbstractJdbc2ResultSet)result).setStatement((Statement)this);
[javac] 
^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/Array.java:49: 
inconvertible types
[javac] found   : org.postgresql.jdbc2.ResultSet
[javac] required: org.postgresql.jdbc2.AbstractJdbc2ResultSet
[javac] this.rawString = 
((AbstractJdbc2ResultSet)rs).getFixedString(idx);
[javac]   ^
[javac] 
/usr/local/src/postgresql-7.3rc1/src/interfaces/jdbc/org/postgresql/jdbc2/Jdbc2Connection.java:14: 
org.postgresql.jdbc2.Jdbc2Connection should be declared abstract; it 
does not define 
getResultSet(java.sql.Statement,org.postgresql.Field[],java.util.Vector,java.lang.String,int) 
in org.postgresql.jdbc1.AbstractJdbc1Connection
[javac] public class Jdbc2Connection extends 
org.postgresql.jdbc2.AbstractJdbc2Connection implements 
java.sql.Connection
[javac]^
[javac] 
/usr/local/src/postgresql-7.3rc1