[HACKERS] Postgresql 8.0.0beta2 unicode problem

[Alexander Serkov]

CREATE TABLE test(word text);
INSERT INTO test VALUES('\342\204\226');

SELECT * FROM test WHERE word='\342\200\242';
or
SELECT * FROM test WHERE word='\342\200\224';
returns word previously inserted instead of zero rows.
_______________________________________________________________
http://www.bigmir.net - поиск по украинским сайтам




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match