BUG #1908: sql support chinese char error

From: "wally" <wally(at)ideassoft(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1908: sql support chinese char error
Date: 2005-09-26 09:08:27
Message-ID: 20050926090827.9E7F1F0DD3@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1908
Logged by: wally
Email address: wally(at)ideassoft(dot)com
PostgreSQL version: 8.0.3,8.0.2
Operating system: fc4,fc3,as4
Description: sql support chinese char error
Details:

when running the following sql clause,the result shoud be empty, but I get
one incorrect row.
if I use pgsql 7.4 running the same sql clause return correctly.
thanks!

ulike=# select group_name from group_info where group_name='';
group_name
------------

(1 row)

ulike=# select group_name from group_info ;
group_name
-------------
fFaf
asgfasf
hjlhjl
dfgdj


fdkfjwr
beijing2008
wws
dhdfj

(11 rows)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tobias Brox 2005-09-26 10:17:33 String Comparision Weirdness
Previous Message M. Bilgehan İMAMOĞLU 2005-09-26 07:06:51 System.InvalidCastException : Object cannot be cast from DBNull to other types