From: | Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | igor <linux_211(at)hotmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Case-sensitive problem |
Date: | 2002-07-02 15:13:31 |
Message-ID: | Pine.LNX.4.33.0207020912400.12450-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Darley | 2002-07-02 15:15:01 | Bad records in table |
Previous Message | Scott Marlowe | 2002-07-02 15:04:30 | Re: namespaces and schemas |