471,073 Members | 1,362 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

varchar of length > 32

We are using a table with a primary key of type varchar[50].
If we try to find entries with select * from <table> where <table.key> =
'<text>';
entries with a key length of more than 32 characters are not found.
Entries with a shorter key are found. Using "Like" instead of "=" works for
varchar keys with length > 32 as well.

Does anybody know about this Problem ?
(We use PostgresQL 7.4.1)

Thanks in advance,
Christian Enklaar.

Nov 23 '05 #1
0 965

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by dmhendricks | last post: by
22 posts views Thread by jdokos | last post: by
7 posts views Thread by James o'konnor | last post: by
3 posts views Thread by Christian Enklaar | last post: by
4 posts views Thread by Nick Chan | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.