Re: Case-sensitive problem

On 28 Jun 2002, igor wrote:

> So ,exactly what I am doing is to migrate all database (MS SQL) to the
> PostgreSQL server also with the dates. But I am still receiving one
> strange problem: When some datatype is defined in MS SQL for example
> like username char(15) and the data there is for example:'peter',then
> what I receive in PostgreSQL is 'peter          ' so exactly 15
> characters. When I make SELECT *  FROM users where username='peter' I
> am not receiving no-one row ,but when I type SELECT * FROM users where
> username='peter         ' then I receive whole row. The migration tool
> which I am using is pgAdmin II and DataBase Migration Wizard ,and
> there I defined change type char from MSSQL to char in PostgreSQL.
> When I try change char to varchar ,or to text I am still receiving the
> same.
>
> Can somebody please help me with that problem?
> Thanks a lot

Hi Igor, I just tried this in postgresql 7.2.1 and it seems like it
auto-chopped the char(10) field I was using for testing, so my advice
would be to first try the latest version of postgresql and see if that
helps.

--
"Force has no place where there is need of skill.", "Haste in every
business brings failures.", "This is the bitterest pain among men, to have
much knowledge but no power." -- Herodotus