Re: [GENERAL] windows 1252 encoding

2005-05-13 Thread Andrei Gaspar
Magnus Hagander wrote: Is there a reason that the windows code page 1252 is not supported? The encoding Latin1 would be the most appropriate, but 1252 is a superset of ISO8859-1 and supports more characters, and when I want to write them through odbc I get an error. psqlodbc 8 converts everythin

[GENERAL] windows 1252 encoding

2005-05-13 Thread Andrei Gaspar
Is there a reason that the windows code page 1252 is not supported? The encoding Latin1 would be the most appropriate, but 1252 is a superset of ISO8859-1 and supports more characters, and when I want to write them through odbc I get an error. psqlodbc 8 converts everything to utf-8 and then send

[GENERAL] Collation problem

2005-05-11 Thread Andrei Gaspar
Hi all, I have a table TranslationDictionary in a database initalized with lc_collation and lc_type de-de . In the table is the value 'Straße' and I can't insert 'Strasse', but when I try to create a foreign key on this table, the value 'Strasse' in the foreign table is unmatched. Is this a bug,

Re: [GENERAL] Intervals

2005-04-26 Thread Andrei Gaspar
I had the same problem and wrote a small function create function hours(timestamp without time zone, timestamp without time zone) RETURNS integer as $$select cast( (cast($2 as date) - cast($1 as date)) * 24 + extract(hour from cast($2 as time) - cast($1 as time)) as integer)$$ language SQL IMMUT